Cant enter Array Formulas!! Help!

[Jerry]

Im trying to make the following formula an Array - the 'HELP' in the
program tells me to hit Apple + Enter - no luck. The postings on here
say to hit Control Shift Enter - still all it does is return me to my
spread sheet and put #VALUE! in my field - even though it gives the
correct ANSWER of 8 in the formula dialog box.

=SUM(IF(B1:B25="1/4", IF(C1:C25="Central Fl",1,0)))

The above formula was taken from a help page in Excell on how to find
a single result from multiple conditions.

Any hints as to Why I cannot make Array Formulas? Particularly with
this one above? Even though it is returning the correct answer in the
dialog box???

WHEN do I hit contrl-shift-enter? At the End? At the begining?

-Frustrated!

 

[J.E. McGimpsey]

Im trying to make the following formula an Array - the 'HELP' in the
program tells me to hit Apple + Enter - no luck. The postings on here
say to hit Control Shift Enter - still all it does is return me to my
spread sheet and put #VALUE! in my field - even though it gives the
correct ANSWER of 8 in the formula dialog box.

=SUM(IF(B1:B25="1/4", IF(C1:C25="Central Fl",1,0)))

The above formula was taken from a help page in Excell on how to find
a single result from multiple conditions.

Any hints as to Why I cannot make Array Formulas? Particularly with
this one above? Even though it is returning the correct answer in the
dialog box???

WHEN do I hit contrl-shift-enter? At the End? At the begining?

Not sure why you're getting a #VALUE! error - array-entering works
fine for me. Perhaps one of your formulae in B1:C25 returns #VALUE!?

On a Mac, either Cmd(Apple)-Enter or CTRL-SHIFT-ENTER can be used to
array enter. You use those combinations while you're still in edit
mode in the cell, and have finished the formula.

However, you can do this without array entering if you use the
SUMPRODUCT() function:

=SUMPRODUCT(--(B1:B25="1/4"),--(C1:C25="Central Fl"))

The -- just convert the TRUE/FALSE values returned by the comparison
to 1/0 values, since SUMPRODUCT requires numeric arrays.