About Us

Spencer101 · 08:38 PM

Quote:

Originally Posted by mleeangel

Trying to get a count using hired before date and termed after date. I am trying to use the cell the date is in. I'm attaching a sample spreadsheet with the formula that I'm using. Thanks for your help and showing me how to fix what I am messing up.
Thanks
Michelle

Try changing the formula in D2 to:

=COUNTIFS(Sheet1!B:B,B2,Sheet1!H:H,"<"&$D$1,Sheet1 !I:I,""&$D$1)

Does that fix it for you?

You may actually wish to use the below version as it will also capture any that fall on the date in D1

=COUNTIFS(Sheet1!B:B,B2,Sheet1!H:H,"<="&$D$1,Sheet 1!I:I,"="&$D$1)

And this one will allow you to drag the formula to populate the other cells:

=COUNTIFS(Sheet1!$B:$B,$B2,Sheet1!$H:$H,"<="&D$1,S heet1!$I:$I,"="&D$1)

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF with Dates	SRL	Excel Worksheet Functions	3	October 27th 08 03:48 PM
Countif and dates	Tom	Excel Worksheet Functions	4	February 14th 08 06:13 PM
CountIF with dates	Secret Squirrel	Excel Discussion (Misc queries)	13	November 15th 06 09:08 PM
using countif to add dates	jwmillzy	Excel Discussion (Misc queries)	2	June 2nd 06 06:27 PM
Countif using dates	Bugaglugs	Excel Worksheet Functions	11	August 23rd 05 05:16 PM

Menu

About Us