Help with Formula for.................
Hi,
Try something like this
=SUMPRODUCT(--(A1:A3="mar"),--(B1:B30),C1:C3)
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Corca" wrote:
Hi All,
Have a problem working a formula for the following:
A B C
1 mar ra123 10
2 mar so123 100
3 apr ra234 20
I need to say, if A1 to A3 is equal to mar and B1 to B32 is equal to
non-blank or 0 then add what's in C corresponding to where mar is found.
I used following:
if(a1:a3=mar,"sumif(b1:b3,"0",c1:c3))
This did not work so can someone please help me, very much appreciated.
|