sum formula

  • Thread starter Thread starter ADIB
  • Start date Start date
A

ADIB

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
 
hi
this might work for you...
=SUMPRODUCT((B2:B4)*(C2:C4>0))

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Back
Top