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

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?

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

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



--
Regards,

Peo Sjoblom




"CD" wrote in message
...
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?

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

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

Just remove the quotes!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"CD" wrote in message
...
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?

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

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


with @tiscali.co.uk


"CD" wrote in message
...
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?