lost_in_the_sauce
Board Regular
- Joined
- Jan 18, 2021
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
I'm creating a report on finances of different locations, and have AverageIF, MaxIf, and MinIf knocked out, but there isn't a MedianIF.
I only have 1 condition to check, it's the column that has the location's state
The other ones are just =AVERAGEIF(C:C,"CA",E:E), so nothing really complicated. If I wanted to take the median of all locations that had CA in column C instead of average, how could I do that?
I only have 1 condition to check, it's the column that has the location's state
The other ones are just =AVERAGEIF(C:C,"CA",E:E), so nothing really complicated. If I wanted to take the median of all locations that had CA in column C instead of average, how could I do that?