B
Biff
Hi Toan,
I just tried it with =SUMIF and got the result, 34, based
on your data. This is the correct answer. Check the format
of the values you have in col A. If they were entered as
text using the ' then the formula will return 0,
otherwise, it should work.
Biff
I just tried it with =SUMIF and got the result, 34, based
on your data. This is the correct answer. Check the format
of the values you have in col A. If they were entered as
text using the ' then the formula will return 0,
otherwise, it should work.
Biff