Maybe "four winds" doesn't match any cell in April's column A?

Maybe the values in column B of that worksheet aren't numbers--maybe they just
look like numbers (text masquerading as numbers).

If you put these in a couple of empty cells in the April worksheet
=count(B:B)
=counta(B:B)
do they match?

The first counts numbers. The second counts non-empty cells.

Indymanny wrote:

I have a workbook set up which has year-to-date running totals.
The report is pulling the previous months numbers from different sheets that
I have added to the end of the workbook once the month is complete. The
formula I have been using,

=SUMIF('Int Mar 07'!A:A,"four winds",'Int Mar 07'!B:B)

has worked fine until this month. When I change the formula to reflect April
(the latest month), all I get are "0"'s. When I tested the formula to pull
from different sheets, still within the workbook, it computes fine. Could
there be something corrupt with the April sheet I just added?

I'm relatively new to Excel so any information would be greatly appreciated!

Thanks!

Indymanny

--

Dave Peterson