Jan 13 2021 07:05 PM
I need help with a formula that would sum up days by month. I'm sure it's something simple however I'm stumped. Please see the screen shots of both sheets below. What I'm trying to accomplish is to reference the "Date" Column data on the "Registration DBASE" sheet to return the sum total number of days on the "Attrition Report" corresponding to the "Recruitment Results" by the listed "Enrollment Month". Just need to calculate total days. Nothing else. Any help would be appreciated.
**See the attached sheets below
Thanks
Dwain
Jan 13 2021 08:59 PM
If not sure I fully understand what you're trying to do, but is this in ballpark? Are you trying to summarize your list by month and status?
Jan 13 2021 09:04 PM
Jan 14 2021 03:50 AM
Yes this is exactly the formula I need. Just added sheet reference to the formula you created.
=SUMPRODUCT(--(TEXT(Registrationdbase!$A$2:$A$9,"MMMM")=A2),--(attrition report!$B$2:$B$9=B2))
Thank you sooooo much!
Dwain