Is it possible to total multiple cells with an "IF" function value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having trouble figuring out how to create a formula to add multiple
cells (not all in the same column or row). The value of these multiple cells
are populated based on the "IF" function I've entered. i.e.: =IF(B4="Package
1","75,000","")
When the field populates with 75,000, excel doesn't seem to recognize it as
a number value since there is a formula in that field. Since excel isn't
recognizing it as a value, I am unable to create a formula that will sum
these multiple cells. That is my guess on what the issue is.
My question is can you add (SUM) cells that are populated based on an "IF"
formula in that cell?
 
You are using text values, if you want to populate with a number use

75000

not

"75000"

so you are wrong, IF formula has nothing to do with it, you are just using
the wrong method by putting numbers with quotations around them
 
When the field populates with 75,000, excel doesn't seem to recognize it
as
a number value
Click to expand...

That is because "75,000"

Try using just 75000 instead.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
Back
Top