How do I multiply 2 cells if a 3rd contains certain text

[Casber]

Hi

I'm trying to find a formula that where row# in Col C =1 AND same row Col A=Q1 I sum the cells in Col B from those rows

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Col A
[/TD]
[TD]Col B
[/TD]
[TD]Col C
[/TD]
[/TR]
[TR]
[TD]Row A
[/TD]
[TD]Q1
[/TD]
[TD]5
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Row B
[/TD]
[TD]Q1
[/TD]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row C
[/TD]
[TD]Q2
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Row D
[/TD]
[TD]Q1
[/TD]
[TD]6
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]Row E
[/TD]
[TD]Q4
[/TD]
[TD]3
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

In my spreadsheet I have to repeat the formula for different cols - A & B would remain constant but C could change.

Col C will only ever include 1 or blank

So far I'd come up with (from web searches - I have no idea!): =SUMIF (A2:A70,"*"&E72&"*",SUMPRODUCT(E2:E70,F2:F70)) but this returns a formula error.

Thanks in advance for any help.

 

[Rick Rothstein]

Re: Formula help: How do I multiply 2 cells if a 3rd contains certain text

Assuming you meant Row 1, Row 2, etc. instead of Row A, Row B, etc., give this formula a try...

=SUMIFS(B1:B5,A1:A5,"Q1",C1:C5,1)

Change all of the 5's to the row number of the last cell with data in it.

 

[Casber]

Re: Formula help: How do I multiply 2 cells if a 3rd contains certain text

Thank you. That's exactly what I wanted