Unable to Sum cells in Excel

Hello,

I am having issues trying to use the SUM function to 
autosum a couple of cells that have If functions within 
them. I am trying to do the following:

In Q12 I am trying to get the Sum of N12, O12 and P12. I 
have only tried =SUM(N12:P12) as the function formatting 
the cell as text, general, numeric etc but the total 
always ends up being 0.00, I never get an addition of the 
values in the other cells. 

Each of the N, O and P cells has the following function 
within it, 

=IF(F12="","",IF(F12>=90%,"5",IF(F12>=85%,"4",IF
(F12>=78%,"3",IF(F12>=72%,"2",IF(F12<72%,"1"))))))

I am basically comparing scores that people have gotten 
against measures they need to meet. This gives them a 
1,2,3,4 or 5 rating. It is the rating that I am trying to 
sum up. 

If anyone could assist helping me get Q12 to add up the 
values it should it would be much appreciated. I am fairly 
new to the excel functions so it is most likely something 
simple.

Thanks
0
5/8/2004 1:44:10 AM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
543 Views

Similar Articles

[PageSpeed] 39

Just delete quotation marks on"1", "2",..., and sum formula will work...


"Brett Walters" <brettwalters@hotmail.com> wrote in message
news:a1db01c4349d$f5272670$a101280a@phx.gbl...
> Hello,
>
> I am having issues trying to use the SUM function to
> autosum a couple of cells that have If functions within
> them. I am trying to do the following:
>
> In Q12 I am trying to get the Sum of N12, O12 and P12. I
> have only tried =SUM(N12:P12) as the function formatting
> the cell as text, general, numeric etc but the total
> always ends up being 0.00, I never get an addition of the
> values in the other cells.
>
> Each of the N, O and P cells has the following function
> within it,
>
> =IF(F12="","",IF(F12>=90%,"5",IF(F12>=85%,"4",IF
> (F12>=78%,"3",IF(F12>=72%,"2",IF(F12<72%,"1"))))))
>
> I am basically comparing scores that people have gotten
> against measures they need to meet. This gives them a
> 1,2,3,4 or 5 rating. It is the rating that I am trying to
> sum up.
>
> If anyone could assist helping me get Q12 to add up the
> values it should it would be much appreciated. I am fairly
> new to the excel functions so it is most likely something
> simple.
>
> Thanks


0
5/8/2004 2:05:39 AM
Remove the quotes from around the numbers in your formulae. "5" is text, 
which SUM() ignores:

=IF(F12="","",IF(F12>=90%,5,IF(F12>=85%,4,IF
(F12>=78%,3,IF(F12>=72%,2,IF(F12<72%,1))))))

In article <a1db01c4349d$f5272670$a101280a@phx.gbl>,
 "Brett Walters" <brettwalters@hotmail.com> wrote:

> Hello,
> 
> I am having issues trying to use the SUM function to 
> autosum a couple of cells that have If functions within 
> them. I am trying to do the following:
> 
> In Q12 I am trying to get the Sum of N12, O12 and P12. I 
> have only tried =SUM(N12:P12) as the function formatting 
> the cell as text, general, numeric etc but the total 
> always ends up being 0.00, I never get an addition of the 
> values in the other cells. 
> 
> Each of the N, O and P cells has the following function 
> within it, 
> 
> =IF(F12="","",IF(F12>=90%,"5",IF(F12>=85%,"4",IF
> (F12>=78%,"3",IF(F12>=72%,"2",IF(F12<72%,"1"))))))
> 
> I am basically comparing scores that people have gotten 
> against measures they need to meet. This gives them a 
> 1,2,3,4 or 5 rating. It is the rating that I am trying to 
> sum up. 
> 
> If anyone could assist helping me get Q12 to add up the 
> values it should it would be much appreciated. I am fairly 
> new to the excel functions so it is most likely something 
> simple.
> 
> Thanks
0
jemcgimpsey (6723)
5/8/2004 2:10:08 AM
Not sure, but would you want to experiment with the Match function:

=MATCH(F12,{0,0.72,0.78,0.85,0.9})

-- 
Dana DeLouis
Using Windows XP  &  Office XP
= = = = = = = = = = = = = = = = =


"Brett Walters" <brettwalters@hotmail.com> wrote in message
news:a1db01c4349d$f5272670$a101280a@phx.gbl...
> Hello,
>
> I am having issues trying to use the SUM function to
> autosum a couple of cells that have If functions within
> them. I am trying to do the following:
>
> In Q12 I am trying to get the Sum of N12, O12 and P12. I
> have only tried =SUM(N12:P12) as the function formatting
> the cell as text, general, numeric etc but the total
> always ends up being 0.00, I never get an addition of the
> values in the other cells.
>
> Each of the N, O and P cells has the following function
> within it,
>
> =IF(F12="","",IF(F12>=90%,"5",IF(F12>=85%,"4",IF
> (F12>=78%,"3",IF(F12>=72%,"2",IF(F12<72%,"1"))))))
>
> I am basically comparing scores that people have gotten
> against measures they need to meet. This gives them a
> 1,2,3,4 or 5 rating. It is the rating that I am trying to
> sum up.
>
> If anyone could assist helping me get Q12 to add up the
> values it should it would be much appreciated. I am fairly
> new to the excel functions so it is most likely something
> simple.
>
> Thanks


0
delouis (422)
5/8/2004 2:21:40 PM
Reply:

Similar Artilces: