Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
I guess the best way to ask this would be with an example. (i was thinking maybe a way to transpose the sumproduct formula) jan feb mar apr may data data data data data data data data data data 1 1 2 1 1 What i'm looking to do is to sum up the #'s based on some criteria (more than 1 criteria, so like data1 < 10 and maybe data2 = 5) in the same column. so say the criteria was true for the feb and march column, i would want the result to be -- 1 + 2 = 3. Any Ideas would be greatly appreciated Thanks, Josh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I fix transposed legend text? | Charts and Charting in Excel | |||
Extend series using ref cell formula transposed | Excel Worksheet Functions | |||
How can I find repeated numbers that are transposed? | Excel Discussion (Misc queries) | |||
= (other sheet, but transposed!) | Excel Discussion (Misc queries) | |||
Transpose into a _working_ transposed array | Excel Discussion (Misc queries) |