Log In
Register
Home
March 29, 2020
Offline
Hi,
Aggregate funtion with IF conditions doesn't work for options like Average and Sum. But it works fine for options Large and Small. Any concerns! 
VIP
Trusted Members
December 7, 2016
Offline
Hello,
Please attach an Excel file instead of pictures, your formulas are referencing columns we don't see in the pictures and not many want to sit and create their own sample data, which may or may not be similar to your data.
There is a nice blog post about this aggregate function, well worth reading.
https://www.myonlinetraininghu.....e-function
As per the help text about this function (https://support.microsoft.com/.....9993fa26df)
Errors:
If a second ref argument is required but not provided, AGGREGATE returns a #VALUE! error.
If one or more of the references are 3-D references, AGGREGATE returns the #VALUE! error value.
Without access to the data I can't really give a better answer.
Br,
Anders
Dashboards
Power Query
February 13, 2021
Offline
It looks like you have the order wrong, it should be IF(D:D="Full Time", AGGREGATE(...),""). As Anders said, we can't give a better answer without seeing the actual spreadsheet.
Trusted Members
November 1, 2018
Offline
The first 13 options for AGGREGATE require a range to process and will not work with an array, which is what your IF function is returning.
March 29, 2020
Offline
Thank you for the reply!
Pls check the google sheets. Pls feel free to edit the google sheets, I have given edit access.
https://docs.google.com/spread.....38;sd=true, https://docs.google.com/spread.....38;sd=true
The following users say thank you to Ahamed Shaakir for this useful post:
Mynda Treacy
1 Guest(s)
