ExcelBanter - adding product to formula...

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - adding product to formula... (https://www.excelbanter.com/excel-discussion-misc-queries/61104-adding-product-formula.html)

NTaylor

adding product to formula...

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
--
Nicki Taylor

Rowan Drummond

adding product to formula...

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

NTaylor wrote:
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

NTaylor

adding product to formula...

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

"Rowan Drummond" wrote:

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

NTaylor wrote:
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

All times are GMT +1. The time now is 03:53 PM.