Posted to microsoft.public.excel.misc

external usenet poster

Posts: 23

Countif between two dates

I have the following formular:

=IF($B5002="","",COUNTIF(MAIN!$B$10:$B$5000,"" &$B5002 & ""))
Column A is the date
Column B is the unit

How do I modify it to count between two dates that are in cells Sheet2 P3
and R3

Thank you
--
AOP

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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	WLMPilot	Excel Worksheet Functions	1	October 7th 05 12:51 AM
Countif using dates	Bugaglugs	Excel Worksheet Functions	11	August 23rd 05 05:16 PM
countif and dates	JAF	New Users to Excel	2	December 3rd 04 04:45 PM

All times are GMT +1. The time now is 08:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us