Forum Discussion
Solved
help with formula
I have a spreadsheet with several tabs of data. I am wanting to count column L for time in minutes and divide it by 60 to get hours in the time period specified on Tab Injury Prevention. My current f...
Dania1215 This is the formula that checks for both begin and end date.
=SUMIFS('Summary of Services'!L2:L9988,'Summary of Services'!A2:A9988,">"&'Injury Management'!D3,'Summary of Services'!A2:A9988,"<"&'Injury Management'!F3)/60
Ok i have redacted a lot of info in that spreadsheet. Let me see if i can upload another version for you to look at. I've tried writing it with the end data date. I have been working on this for days and I can't seem to push through it. I'm about to lose my mind. I will see if I can tag you.
Dania1215 This is the formula that checks for both begin and end date.
=SUMIFS('Summary of Services'!L2:L9988,'Summary of Services'!A2:A9988,">"&'Injury Management'!D3,'Summary of Services'!A2:A9988,"<"&'Injury Management'!F3)/60
- OMG! I think i was missing the quotation and a comma. THIS WHOLE TIME! Ugh. Thank you SOOOO much! Riny_van_Eekelen
Dania1215 That happens to all of us, sometimes! Glad I could help.