Formula result not displaying on worksheet
 

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"),D2:D11) ). 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?

Formula result not displaying on worksheet
 

Could be that you didn't enter using ctrl+shift+enter
=sumproduct((A2:A11="South")*(C2:C11="Meat"),D2:D1 1)
This should give your sum without array entering.
--
Don Guillett
SalesAid Software

"MsBeverlee" wrote in message
...
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"),D2:D11) ). 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?

Formula result not displaying on worksheet
 

typo change comma to *

=sumproduct((A2:A11="South")*(C2:C11="Meat"),D2:D1 1)
=sumproduct((A2:A11="South")*(C2:C11="Meat")*D2:D1 1)

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
Could be that you didn't enter using ctrl+shift+enter
=sumproduct((A2:A11="South")*(C2:C11="Meat"),D2:D1 1)
This should give your sum without array entering.
--
Don Guillett
SalesAid Software

"MsBeverlee" wrote in message
...
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"),D2:D11) ). 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?

Formula result not displaying on worksheet
 

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(D2:D11)))

Better to use cells to hold the criteria:

F1 = south
F2 = meat

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

Biff

"MsBeverlee" wrote in message
...
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"),D2:D11) ). 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?

Formula result not displaying on worksheet
 

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

"T. Valko" wrote:

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(D2:D11)))

Better to use cells to hold the criteria:

F1 = south
F2 = meat

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

Biff

"MsBeverlee" wrote in message
...
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"),D2:D11) ). 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?

Formula result not displaying on worksheet
 

You're welcome. Thanks for the feedback!

Biff

"MsBeverlee" wrote in message
...
Thank you so much! It worked! I appreciate your help!

"T. Valko" wrote:

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(D2:D11)))

Better to use cells to hold the criteria:

F1 = south
F2 = meat

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

Biff

"MsBeverlee" wrote in message
...
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"),D2:D11) ). 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?