counting days in a range

G

Guest

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.
 
G

Guest

I would use
=sumproduct(--(A1:A10<=15))
=sumproduct(--(A1:A10>15),--(A1:A10<=30))
=sumproduct(--(A1:A10>30),--(A1:A10<=60))
=sumproduct(--(A1:A10>60))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Account Receivable Aging Report 1
Sumproduct Problem 4
Excel Formula - Count Dates from another Sheet 8
Calculating Days Late 1
Formula not reading date format 3
Excel Colour code dates 1
value time formula help please 4
Count specific days in between dates 2

Top