sum formula returns zero value

  • Thread starter Thread starter Roberta
  • Start date Start date
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?
 
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?
|
|
 
Back
Top