L
laandmc
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??
"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??