Hi Everyone,
I need help to make this report by Formula. I tried to use this formula but it is not working. please help me.
Please Login or Register to view this content.
Hi Everyone,
I need help to make this report by Formula. I tried to use this formula but it is not working. please help me.
Please Login or Register to view this content.
Try
=SUMPRODUCT((MONTH('Main Database'!$B$2:$B$52)=MONTH(B3))*('Main Database'!$H$2:$H$52<>""))
Dates in B3:B6 amended to be Excel dates formatted as "mmmm"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks