Product sum??? summing cells if a condition is true! PLEASE HELP!!
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?? |
Product sum??? summing cells if a condition is true! PLEASE 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?? |
All times are GMT +1. The time now is 03:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com