Thread: Sumifs function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Sumifs function

What does this mean?

It usually means the cell is formatted as TEXT.

Change the cell format to GENERAL. Then hit function key F2 then hit ENTER.

--
Biff
Microsoft Excel MVP


"Alan" wrote in message
...
I've entered the formula, it appears correct, and the correct result is
displayed in the function argument box, however only the formula displays
in
the cell. What does this mean?