Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a Column G2:G300, which contains the difference between dates.
What I need to do is average only rows that have certain values. To simplify, I K2:G300 only contains two values (True and False) How do I do an Average of all the columns (G2:G300) where the value in "K" for that row equals True. I then need to have a seperate average for the rows that contain False. Appreciate any help on this. KSL |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Average | Excel Discussion (Misc queries) | |||
Conditional Average | Excel Worksheet Functions | |||
Conditional Average | Excel Worksheet Functions | |||
Conditional Average | Excel Worksheet Functions | |||
Conditional Average | Excel Discussion (Misc queries) |