ExcelBanter - sum formula

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

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

- - sum formula (https://www.excelbanter.com/excel-discussion-misc-queries/220842-sum-formula.html)

ADIB

sum formula

please help me for the following

A B C
20 5 15
30 30
50 20 30

i want to sum b1:b3 if c1:c3 having value it mean b4 would be 25
please suggest me how i make formula for above Q
Thanks

FSt1

sum formula

hi
this might work for you...
=SUMPRODUCT((B2:B4)*(C2:C40))

regards
FSt1

"ADIB" wrote:

please help me for the following

A B C
20 5 15
30 30
50 20 30

i want to sum b1:b3 if c1:c3 having value it mean b4 would be 25
please suggest me how i make formula for above Q
Thanks

All times are GMT +1. The time now is 12:29 AM.