View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MsBeverlee MsBeverlee is offline
external usenet poster
 
Posts: 29
Default 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?