Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This sounds simple but is proving tricky
I have row of booleans a1:l1 and want to sum rows below that a3:l7 according to the booleans value, but how could this be done in 1 cell sumif wont work because the ranges are different shapes so it only does row 3. I think the problem is row/column ambiguity of course you could sub total rows or columns or do multiple sumifs in one cell, but is there a better way? Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Moving data from multiple rows to single rows | Excel Worksheet Functions | |||
Sum single or duplicate rows with multiple criteria | Excel Worksheet Functions | |||
Multi rows to single row | Excel Discussion (Misc queries) | |||
Multiple rows from a single row | Excel Discussion (Misc queries) |