Sanjay Gandhi
asked on
COUNTIFS Date Range With Month
Hi,
I have a range of dates spanning from one month to other months. Then I have a summary where there are months. Now in the summary I want the count to be done for months seeing the dates in the range.
Attached is the file which explains the problem. Appears simple, but I tried a v-e-r-y big formula to achieve this. Any better way?
Thanks,
San.CountIFs-Month.xlsx
I have a range of dates spanning from one month to other months. Then I have a summary where there are months. Now in the summary I want the count to be done for months seeing the dates in the range.
Attached is the file which explains the problem. Appears simple, but I tried a v-e-r-y big formula to achieve this. Any better way?
Thanks,
San.CountIFs-Month.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Open in new window