I am trying to create a formula that will take data from one column and based
upon that data count data in another column. My column C2:C112 holds state
names (FL) and my column H2:H112 holds dates (12/8/08). The formula needs to
count the number of dates in column H for all corresponding rows in column C.
So if I have 10 rows in column C with FL in it and only 3 with dates in
column H I only want it to add those 3 on a separate worksheet.

Try this:

=SUMPRODUCT((sheet1!C2:C112="FL")*(sheet1!H2:H112< ""))

This doesn't specifically test for a date, as that is just a number to
Excel, so it tests for the cell in column H not being blank.

Hope this helps.

Pete

On Jan 22, 9:15*pm, RennStempie2
wrote:
I am trying to create a formula that will take data from one column and based
upon that data count data in another column. *My column C2:C112 holds state
names (FL) and my column H2:H112 holds dates (12/8/08). *The formula needs to
count the number of dates in column H for all corresponding rows in column C.
*So if I have 10 rows in column C with FL in it and only 3 with dates in
column H I only want it to add those 3 on a separate worksheet.

It's not real clear what you want to do.

Do you want to count the dates that correspond to FL? If so, try this:

=SUMPRODUCT(--(C2:C112="FL"),--(ISNUMBER(H2:H112)))

--
Biff
Microsoft Excel MVP


"RennStempie2" wrote in message
...
I am trying to create a formula that will take data from one column and
based
upon that data count data in another column. My column C2:C112 holds
state
names (FL) and my column H2:H112 holds dates (12/8/08). The formula needs
to
count the number of dates in column H for all corresponding rows in column
C.
So if I have 10 rows in column C with FL in it and only 3 with dates in
column H I only want it to add those 3 on a separate worksheet.