=SUMPRODUCT(($E$9:$E$202="

regards, barry

Solved

Posted on 2011-10-20

I have the formula below in a spreadsheet I'm working on. I'm using Excel 2010. This statement worked fine when I was total just one column. However, I'd like to modify this to add up multiple columns. I have a row ("E") that contains either "T7" or "T3". If the row is a T3, I'd like to total columns F,G,H, and I. This formula is only summing the first column (F). I've tried this with other columns (J,K,L, and M) with the same result.

Any ideas? I also tried without the absolutes, but that didn't work either.

=SUMIF($E$9:$E$202,"T3",$F$9:$I$202)

Any ideas? I also tried without the absolutes, but that didn't work either.

=SUMIF($E$9:$E$202,"T3",$F

```
=SUMIF($E$9:$E$202,"T3",$F$9:$I$202)
```

11 Comments

=SUMPRODUCT(($E$9:$E$202="

regards, barry

Or

You could have several sumif statements within the same formula i.e.

=sumif(e9:e202, "T3", f9) + sumif(.........)

Hope this helps

Andy

There's a "one-to-one" relationship in SUMIF - F9 is summed if E9 is T3, G9 will only be added if F9 =T3.....

regards, barry

=SUM(IF($E$9:$E$202="T3",$

Confirm entry with Ctrl + Shift + Enter rather than just Enter. This will add curly brackets at start and finish so will end looking like:

{=SUM(IF($E$9:$E$202="T3",

Thanks

Rob H

regards, barry

By clicking you are agreeing to Experts Exchange's Terms of Use.

Title | # Comments | Views | Activity |
---|---|---|---|

VBA Excel Gantt | 1 | 27 | |

Trying to fix NUMBER ARRANGE Button to load faster and more efficiently. | 20 | 22 | |

Select a random value from list and chg background color. | 5 | 22 | |

Assign Month to the Date Range (via VBA) | 5 | 27 |

Join the community of 500,000 technology professionals and ask your questions.

Connect with top rated Experts

**16** Experts available now in Live!