I want to use a formular to say that if certain cells equal to a word, say
"nov" then to times the sum of the corresponding cells together
What I have so far is using a sum product formula, this times' them all out
individually so I get 0*0.5% which then gets rid of that 0.5% which I need to
keep

I want to get whenever there appears a nov in column b c and d for the
correspondiong cells to be added up and times together.

amount 0 100 50

percent 0.50% 0.50% 0.50%

date nov nov nov


product 0.75 <-- = SUMPRODUCT(A4:C4,A6:C6,(A8:C8="nov")*1)

product (2) 2.25 <-- = =(0+100+50)*(0.5%+0.5%+0.5%)

Please can anyone help??

=SUMIF(A8:C8,"Nov",A4:C4)*SUMIF(A8:C8,"Nov",A6:C6)

You could of course replace 'Nov" with a cell reference to some other cell
to help make the formula more dynamic.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"laandmc" wrote:

I want to use a formular to say that if certain cells equal to a word, say
"nov" then to times the sum of the corresponding cells together
What I have so far is using a sum product formula, this times' them all out
individually so I get 0*0.5% which then gets rid of that 0.5% which I need to
keep

I want to get whenever there appears a nov in column b c and d for the
correspondiong cells to be added up and times together.

amount 0 100 50

percent 0.50% 0.50% 0.50%

date nov nov nov


product 0.75 <-- = SUMPRODUCT(A4:C4,A6:C6,(A8:C8="nov")*1)

product (2) 2.25 <-- = =(0+100+50)*(0.5%+0.5%+0.5%)

Please can anyone help??