sum formula returns zero value

R

Roberta

I have a 23 cells I want to sum together . Each cell is
populated based on the sumif function. If I try to to sum
more than 4 cells it returns a zero alue. I am not sure
what I am doing wrong. Please help. Do I need to be
careful of the format or am I using the wrong formula?
 
P

Pieter Kuyck

Maybe one the cells has not a number but a text value

Range = the range you want to evalute
Cell = cell with value for the criteria
Sum_Range = the range to sum

SumIf which will count al the text value which are numbers
=SUMPRODUCT((Range=Cell)*(Sum_Range))

Pieter


| I have a 23 cells I want to sum together . Each cell is
| populated based on the sumif function. If I try to to sum
| more than 4 cells it returns a zero alue. I am not sure
| what I am doing wrong. Please help. Do I need to be
| careful of the format or am I using the wrong formula?
|
|
 

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
Zero and Null Sum Function 3
Sum Function has small remainder 2
Adding recognised Zeros 5
Hide columns based on row values 2
Despite formula I use (for example SUM) result is always zero. 5
IF Function error #VALUE 2

Top