Same formula with different variable

J

Jack

I am using a spreadsheet for counting in a large
environment and I have the formula
{=SUM(IF(Detailed!$D$2:$D$339=A4,IF(Detailed!
$M$2:$M$339="Retired",1,0)))}
working fine, but this formula will not:
{=SUM(IF(Detailed!$D$2:$D$339=A4,IF(Detailed!
$M$2:$M$339="Upgraded",1,0)))}

I only copied the cell and paste special w/formula and
then changed the word "Retired" to "Upgraded" in the
formula. I need both formulas to work to display the info
I need.
FYI-it works in the new cell with Retired but not Upgraded.
Any ideas?
 
B

Bob Phillips

Do you have any values of Upgraded?

You do commit with Ctrl-Shift-Enter?

Else, what error do you get?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
G

Guest

Yes,
Yes,
and there are no errors, just a value of 0.
I did make it work eventually by cleaning up the value
fields.
Thanks
 
Top