Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
horizontal sumif help
Hi,
I'm trying to do this =sumif(A1:G1,"HO",K1:Q1) A1 B1 C1 D1 E1 F1 G1 ....K1 L1 M1 N1 O1 P1 Q1.........AZ (RESULT) O HO O O O HO O 2 4 5 56 2 2 1 6 But don't work, any idea? Thanks! Marcelo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
How to use SUMIF function with non-adjacent cells | Excel Worksheet Functions | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
SUMIF | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |