Sumif

[Barb]

Hello and thank you in advance for any assistance you can
give.

I have a worksheet formula that isn't working, well it
would display the number, but shows #value. The
calculation is correct in the formula bar. How can I get
it to display the result.
This is my formula:
=SUM(IF(E10:AI10="S",E9:AI9,0))

Regards,
Barb

 

[RagDyeR]

Your formula is an array formula and must be entered using CSE (<Ctrl>
<Shift> <Enter>).

Everything else looks fine!

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Hello and thank you in advance for any assistance you can
give.

I have a worksheet formula that isn't working, well it
would display the number, but shows #value. The
calculation is correct in the formula bar. How can I get
it to display the result.
This is my formula:
=SUM(IF(E10:AI10="S",E9:AI9,0))

Regards,
Barb

 

[Michael Malinsky]

Your formula works (almost) fine when I tested it on my machine. The only
change I made (providing that you want to sum each cell in row 9 for which
the cell in the corresponding row 10 contains an S) was to enter the formula
as an array by going into edit mode in the formula bar and pressing
Ctrl+Alt+Enter.

The result was to return, for example 5, if only 5 cells in range E10:AI10
contained the letter S.



--
Michael J. Malinsky
Pittsburgh, PA

"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winnie the Pooh

 

[Mike Lee]

If you don't want to go with an array formula, you could
use this:

=SUMIF(E10:AI10,"S",E9:AI9)

Hope that helps.

Mike