Help With Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2059254%22%20slang%3D%22en-US%22%3EHelp%20With%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2059254%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20with%20a%20formula%20that%20would%20sum%20up%20days%20by%20month.%20I'm%20sure%20it's%20something%20simple%20however%20I'm%20stumped.%20Please%20see%20the%20screen%20shots%20of%20both%20sheets%20below.%20What%20I'm%20trying%20to%20accomplish%20is%20to%20reference%20the%20%22Date%22%20Column%20data%20on%20the%20%22Registration%20DBASE%22%20sheet%20to%20return%20the%20sum%20total%20number%20of%20days%20on%20the%20%22Attrition%20Report%22%20corresponding%20to%20the%20%22Recruitment%20Results%22%20by%20the%20listed%20%22Enrollment%20Month%22.%20Just%20need%20to%20calculate%20total%20days.%20Nothing%20else.%20Any%20help%20would%20be%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E**See%20the%20attached%20sheets%20below%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%26nbsp%3B%3C%2FP%3E%3CP%3EDwain%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2059254%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2059393%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20With%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2059393%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F928451%22%20target%3D%22_blank%22%3E%40gourddw%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20not%20sure%20I%20fully%20understand%20what%20you're%20trying%20to%20do%2C%20but%20is%20this%20in%20ballpark%3F%20Are%20you%20trying%20to%20summarize%20your%20list%20by%20month%20and%20status%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22JMB17_0-1610599979188.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246323i6666D0A2398A1937%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22JMB17_0-1610599979188.png%22%20alt%3D%22JMB17_0-1610599979188.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2059396%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20With%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2059396%22%20slang%3D%22en-US%22%3EOr%2C%20does%20each%20day%20in%20the%20data%20only%20count%20once%20(so%2C%20January%20would%20be%202)%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2060153%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20With%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2060153%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F928451%22%20target%3D%22_blank%22%3E%40gourddw%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20PivotTable%20could%20be%20a%20solution%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2060439%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20With%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2060439%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675152%22%20target%3D%22_blank%22%3E%40JMB17%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%20this%20is%20exactly%20the%20formula%20I%20need.%20Just%20added%20sheet%20reference%20to%20the%20formula%20you%20created.%3C%2FP%3E%3CP%3E%3DSUMPRODUCT(--(TEXT(Registrationdbase!%24A%242%3A%24A%249%2C%22MMMM%22)%3DA2)%2C--(attrition%20report!%24B%242%3A%24B%249%3DB2))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20sooooo%20much!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDwain%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

4 Replies

@gourddw 

 

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?

 

JMB17_0-1610599979188.png

 

Or, does each day in the data only count once (so, January would be 2)?

@gourddw 

Perhaps PivotTable could be a solution

@JMB17 

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