| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
