Formula result not displaying on worksheet

[MsBeverlee]

The result of a Count(IF . . .) formula is showing in the function arguments
box, but not on the actual worksheet. How do you resolve this so the formul
result displays on the worksheet. The formula I used was
=COUNT(IF((A2:A11="South")*(C2:C11="Meat"),D211)). On the worksheet, the
result shows as 0. But when I click on the "More Functions" drop down on the
toolbar, to see the function arguments, the correct result of "3" shows. How
do I get it show on the actual worksheet?

 

[Don Guillett]

Could be that you didn't enter using ctrl+shift+enter
=sumproduct((A2:A11="South")*(C2:C11="Meat"),D211)
This should give your sum without array entering.

 

[Don Guillett]

typo change comma to *

=sumproduct((A2:A11="South")*(C2:C11="Meat"),D211)

=sumproduct((A2:A11="South")*(C2:C11="Meat")*D211)

 

[T. Valko]

That particular formula needs to be entered as an array. Type in the formula
then use the key combination of CTRL,SHIFT,ENTER (not just ENTER).

A non-array alternative:

=SUMPRODUCT(--(A2:A11="south"),--(C2:C11="meat"),--(ISNUMBER(D211)))

Better to use cells to hold the criteria:

F1 = south
F2 = meat

=SUMPRODUCT(--(A2:A11=F1),--(C2:C11=F2),--(ISNUMBER(D211)))

Biff

 

[MsBeverlee]

Thank you so much! It worked! I appreciate your help!

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Thank you so much! It worked! I appreciate your help!