adding product to formula...

N

NTaylor

Hello,

I ALMOST have what I need, but not quite. I need for the following formula
to also multiply column C by column B (in 'Q Info')... what do I add?

=SUMIF('Q Info'!A:A, 'Per Sales'!A132, 'Q Info'!C:C)

Any help appreciated. Thanks
 
R

Rowan Drummond

Try:

=SUMPRODUCT(--('Q Info'!$A$1:$A$1000='Per Sales'!A132),
'Q Info'!$B$1:$B$1000*'Q Info'!$C$1:$C$1000)

Note you can't use entire columns with the sumproduct formula.

Hope this helps
Rowan
 
N

NTaylor

Thanks! I didn't realize you couldn't do it when choosing the whole column.
This should work. Regards, Nicki
 
Top