Thread: Sumifs function
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Sumifs function

2 possibilities:

1) Cell is formatted as test. Check cell formatting, changing to something
appropriate, then try re-entering formula. (select cell, press F2, and then
Enter to confirm)

2) Formula display mode is enabled. Try pressing Ctrl+`
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Alan" wrote:

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?