Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif across multiple ranges
I have a sumif formula situation that is killing me.
Column C, D, E, F, and G all have ranges of numbers divided into groups (5 rows to a group). I have 6 groups total. Every row after each group has a row that adds all the numbers for that group. A1: Name B1: H C1: 100 D1: $1000 E1: $2000 F1: 50 G1: $5000 I need a formula that will allow me to add columns C, D, E, F, and G based on whether or not it has a "H" in B. I tried: =sumif($C5:$C52,"L",D48:D52,D37:D42,D26:D31,D16:D2 0,D5:D10) but there are too many groups, after D37:D42, it says I have too many. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif across multiple ranges
The formula is =sumif($C5:$C52,"H",D48:D52,D37:D42,D26:D31,D16:D2 0,D5:D10), I
had accidentally used L in the example above. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif across multiple ranges
=SUMIF($B5:$B52,"L",$C5:$C52)
HTH Kostis Vezerides On Jun 27, 4:31 pm, Jarod wrote: I have a sumif formula situation that is killing me. Column C, D, E, F, and G all have ranges of numbers divided into groups (5 rows to a group). I have 6 groups total. Every row after each group has a row that adds all the numbers for that group. A1: Name B1: H C1: 100 D1: $1000 E1: $2000 F1: 50 G1: $5000 I need a formula that will allow me to add columns C, D, E, F, and G based on whether or not it has a "H" in B. I tried: =sumif($C5:$C52,"L",D48:D52,D37:D42,D26:D31,D16:D2 0,D5:D10) but there are too many groups, after D37:D42, it says I have too many. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif across multiple ranges
You know, I was REALLY overthinking that formula! Thanks! I was worried it
was going to count the group totals, but forgot I wouldn't be putting H or L in that cell! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF Multiple Criteria in different ranges. | Excel Worksheet Functions | |||
SUMIF using two ranges | Excel Discussion (Misc queries) | |||
How to SUMIF multiple ranges? | Excel Discussion (Misc queries) | |||
SumIF Multiple Ranges | Excel Worksheet Functions | |||
select multiple cell ranges in "sumif" formula? | Excel Worksheet Functions |