I am trying to use the conditional sum wizard to sum up the numbers in
entries on a spreadsheet that fall within specific month and year date
ranges. I've done this before many times but today I can't seem to get the
wizard to work correctly.

My Conditional Sum formula is as follows:

=SUM(IF('PCA Review'!$U$5:$U$500=2004,IF('PCA Review'!$T$5:$T$500="Oct",'PCA
Review'!$I$5:$I$500,0),0))

If I just put in the month, in this case "Oct" the formula works. If I add
the condition of 2004, it returns zero (0). If I put 2004 in quotation marks
i.e. "2004" then the formula works.

I am using a control on the worksheet to change the year and month inside
the formula so that the user can select the month and year he wants. I've
done this on other spreadsheets, but this one doesn't want to accept just
2004.

Is there some setting that I am missing here. Should I just try SumProduct
instead?

Maybe my worksheet is just posessed. I'll go get some Holy Water, . . .

Anyone know what is going on here?

Will

It's because your date values are text, for the 2004 column copy an empty
cell
select U5:U500, do edit paste special and select add, then try without
quotations

--

Regards,

Peo Sjoblom


"WillRn" wrote in message
...
I am trying to use the conditional sum wizard to sum up the numbers in
entries on a spreadsheet that fall within specific month and year date
ranges. I've done this before many times but today I can't seem to get the
wizard to work correctly.

My Conditional Sum formula is as follows:

=SUM(IF('PCA Review'!$U$5:$U$500=2004,IF('PCA
Review'!$T$5:$T$500="Oct",'PCA
Review'!$I$5:$I$500,0),0))

If I just put in the month, in this case "Oct" the formula works. If I add
the condition of 2004, it returns zero (0). If I put 2004 in quotation
marks
i.e. "2004" then the formula works.

I am using a control on the worksheet to change the year and month inside
the formula so that the user can select the month and year he wants. I've
done this on other spreadsheets, but this one doesn't want to accept just
2004.

Is there some setting that I am missing here. Should I just try SumProduct
instead?

Maybe my worksheet is just posessed. I'll go get some Holy Water, . . .

Anyone know what is going on here?

Will