LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Countif and Sumif functions not working in Excel 2007

I have some workbooks that are in Excel 97-2003 (.xls) format. There are
sumif and countif calculations in them, which work fine if I open the
workbooks in Microsoft Excel 2000. However, the calculations are not working
when I open the workbooks in Microsoft Excel 2007. I have tried re-inputting
the formulas, but still get a "zero" result. What's wrong?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with countif and sumif functions Clay Excel Worksheet Functions 8 June 5th 08 04:11 AM
Skipping cells for SUMIF or COUNTIF functions?? Zilla[_2_] Excel Worksheet Functions 9 February 28th 07 03:43 PM
COUNTIF and SUMIF Functions DCSwearingen Excel Discussion (Misc queries) 6 July 12th 06 08:18 PM
Excel FUNCTIONS stop working suekh Excel Worksheet Functions 3 July 10th 06 05:10 PM
SUMIF and COUNTIF functions Heather Excel Discussion (Misc queries) 1 March 5th 06 07:59 AM


All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"