"If then Sum" Formula in Excel 1

[mkuethe]

I'm struggling with an Excel spreadsheet that contains 91 rows. What I’m trying to do is:

Sum all rows in Column G when Column B=.0001 and Column E=1 within the same row. In other words, only add cells in Column G if, within that same row, Column B=.0001 and E-1.

Make sense?

Can anyone provide me an example of the formula I should use?

Thanks!

 

[AnotherHiggins]

[COLOR=blue white]=sumproduct((B1:B91=.0001)*(E1:E91=1)*(G1:G91))[/color]

Note: the range in each section of the SumProduct must contain the same number of cells. That is, you can't have B1:B91 in one part and then G1:G100 in another.

Also, you can't use SumProduct with an entire column (B:B). But you can use ranges as large as B1:B65535.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[mkuethe]

That worked! Thanks!

 

[AnotherHiggins]

Glad to help!


[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.