Thread: sum formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ADIB ADIB is offline
external usenet poster
 
Posts: 20
Default 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