if statement for summing cells
Hi,
you don't need to check for numbers, sum ignores non-numerics.
Supposing, that formula =IF(V48<0,"ND",IF(V48<0.2,"TR",V48)) is in W48
(better to tell in range W46:W49, and you need the total in W50 and
following:
W50 = sum(W46:W49) - sum of numbers
W51 = sumif(W46:W49,"ND",v46:v49) - sum of ND
W52 = sumif(W46:W49,"TR",v46:v49) - sum of TR
Does this help? Maybe I didn't understand your question fully (my
understanding changed after your second post).
Regards,
Ivan
|