Posted to microsoft.public.excel.misc

Roy

external usenet poster

Posts: 53

counting days in a range

Hi,

I need to count days that an item is open e.g. 0-15 days, 16-30, 31-60,61+.
I can get the 0-15 and 61+ using this formula

=SUMPRODUCT(--(COUNTIF(A2:A10,"<15"))

How can I count the items that are open 16-30 and 31-60 days.

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
counting days	belvy123	Excel Discussion (Misc queries)	2	March 23rd 07 07:14 AM
counting days?	Richard	Excel Discussion (Misc queries)	2	August 1st 06 02:37 PM
Counting days	Crusty	Excel Discussion (Misc queries)	4	August 13th 05 07:49 PM
Counting days	tinkertron	Excel Worksheet Functions	5	April 7th 05 08:11 AM
counting days	Anthony	Excel Discussion (Misc queries)	4	February 3rd 05 09:08 PM

All times are GMT +1. The time now is 03:13 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us