ExcelBanter - counting days in a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - counting days in a range (https://www.excelbanter.com/excel-discussion-misc-queries/140770-counting-days-range.html)

Roy

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.

counting days in a range

I would use
=sumproduct(--(A1:A10<=15))
=sumproduct(--(A1:A1015),--(A1:A10<=30))
=sumproduct(--(A1:A1030),--(A1:A10<=60))
=sumproduct(--(A1:A1060))
"Roy" wrote:

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.

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