- My report has a 'Data(Raw)' tab and 'Dashboard' tab.
-I'm trying count the date values located at 'DATA (RAW)'!BH:BH but only if
it is less than, greater than and equal to value located on Dashboard tab
cell "AD3" (AD3 is equal to today's date)

I'm trying to use the following statements:

=COUNTIF('DATA (RAW)'!BH:BH,"<AD3")
=COUNTIF('DATA (RAW)'!BH:BH,"AD3")
=COUNTIF('DATA (RAW)'!BH:BH,"=AD3")

This is not working for me. Can anyone assist?

Ken

=COUNTIF('DATA (RAW)'!BH:BH,"<"&AD3)

etc.


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Ken" wrote in message
...
- My report has a 'Data(Raw)' tab and 'Dashboard' tab.
-I'm trying count the date values located at 'DATA (RAW)'!BH:BH but only
if
it is less than, greater than and equal to value located on Dashboard tab
cell "AD3" (AD3 is equal to today's date)

I'm trying to use the following statements:

=COUNTIF('DATA (RAW)'!BH:BH,"<AD3")
=COUNTIF('DATA (RAW)'!BH:BH,"AD3")
=COUNTIF('DATA (RAW)'!BH:BH,"=AD3")

This is not working for me. Can anyone assist?

Ken

Try

=COUNTIF('DATA (RAW)'!BH:BH,""&Dashboard!AD3)

Mike

"Ken" wrote:

- My report has a 'Data(Raw)' tab and 'Dashboard' tab.
-I'm trying count the date values located at 'DATA (RAW)'!BH:BH but only if
it is less than, greater than and equal to value located on Dashboard tab
cell "AD3" (AD3 is equal to today's date)

I'm trying to use the following statements:

=COUNTIF('DATA (RAW)'!BH:BH,"<AD3")
=COUNTIF('DATA (RAW)'!BH:BH,"AD3")
=COUNTIF('DATA (RAW)'!BH:BH,"=AD3")

This is not working for me. Can anyone assist?

Ken

Thanks Mike and Bob!

It is now counting the values but the numbers don't match up. When I
manually count to see how many dates are todays date I get 623,
unfortunately the formula counted 659. Any ideas why there is a difference?
Same thing is happening if I change it to < , my manual count is 146 but the
formula count is 150.

Regards,

Ken

"Mike H" wrote:

Try

=COUNTIF('DATA (RAW)'!BH:BH,""&Dashboard!AD3)

Mike

"Ken" wrote:

- My report has a 'Data(Raw)' tab and 'Dashboard' tab.
-I'm trying count the date values located at 'DATA (RAW)'!BH:BH but only if
it is less than, greater than and equal to value located on Dashboard tab
cell "AD3" (AD3 is equal to today's date)

I'm trying to use the following statements:

=COUNTIF('DATA (RAW)'!BH:BH,"<AD3")
=COUNTIF('DATA (RAW)'!BH:BH,"AD3")
=COUNTIF('DATA (RAW)'!BH:BH,"=AD3")

This is not working for me. Can anyone assist?

Ken