Sum Function on reference cell

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
use month in cell date to sum all relevant cells 2
Mapping integers to strings 6
Help with SUMIFS 2
Using SUM(INDIRECT()) 2
VB Script reference cells for in current table? 1
Dsum and Dmax with structured references 1
IF Function not working as I want 1

Top