Hello,
I am using countifs based on criteria of range of days but need to count how many times that was generated on every row. Here is an example to explain what I need to generate:
Data of number of days:
=====
0 —- count of 0 days = 3 times
42 — count of 42 days = 7 times
30 — count of 30 days = 3 times
So based on the above data, the initial count using countifs would be
6-15 days ———> 0 times
16-45 days ——> 2 times
But what I need is to sum all the counts for any particular range . So wanted result for 16-45 days should be 7+3 = 10 not 1. Thanks for help
Bookmarks