countif trouble

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Craig - 29 Dec 2005 09:07 GMT

Hi there, I'm trying to do a countif function on calendar cells.
I have sheets named "Jan" thru "Dec" and the range is "D6" thru M35"
I can't seem to get this function to work!

I've a few different ways including naming the range.

This is the base of the function I am looking for:
=countif(Jan!D6:Dec!M35,"Craig")

What am I doing wrong?

Thank again in advance!
Craig

Reply to this Message

Bob Phillips - 29 Dec 2005 11:04 GMT

Craig,

Put the names of the sheets in C1:c12, and use

=SUMPRODUCT(COUNTIF(INDIRECT("'"&C1:C12&"'!D6:M35"),"Craig"))

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> Hi there, I'm trying to do a countif function on calendar cells.
> I have sheets named "Jan" thru "Dec" and the range is "D6" thru M35"
[quoted text clipped - 9 lines]
> Thank again in advance!
> Craig

Reply to this Message