counting days in a range

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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))
 
Back
Top