Formula result not displaying on worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Could be that you didn't enter using ctrl+shift+enter
=sumproduct((A2:A11="South")*(C2:C11="Meat"),D2:D11)
This should give your sum without array entering.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
sumif functions based on multiple data 2
formula displays as a formula, not as its result 1
how do i count values based on multiple criteria 2
vLookup returns formula and not result 4
maxa function results in value error in worksheet 2
CONCATENATE not producing any results 3
strange conditional format behavior 5

Back
Top