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

[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?

 

[Peo Sjoblom]

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

 

[Ragdyer]

The issue is the quotes around your number, 75,000.

Just remove the quotes!

 

[Sandy Mann]

When the field populates with 75,000, excel doesn't seem to recognize it

as
a number value

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