I'm stuck on the proper combination of Vlookup & Sumif. In my attached spreadsheet, I'm looking for the following results
If Column D (1.20) is "PONCE", what's the Sum of HR12 (Column G) for Sunday 1/14?
Thank you!!
I'm stuck on the proper combination of Vlookup & Sumif. In my attached spreadsheet, I'm looking for the following results
If Column D (1.20) is "PONCE", what's the Sum of HR12 (Column G) for Sunday 1/14?
Thank you!!
Try
=SUMIFS('01.20'!K4:K577,'01.20'!D4:D577,"PONCE",'01.20'!G4:G577,"HR12")
You may be able to remove the single quotes
Last edited by Special-K; 01-24-2018 at 01:06 PM.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Although I don't know exactly where the formula should be, but I ASSUME that it should be in sheet '1.20 WAF'
Also, I don't know if you want to sum all of the week ending or just on that specific.
But I've created a formula below that only ASSUME you want to sum just the week ending (only for 1 week).
Please Login or Register to view this content.
How would I pull only the sum of HR12's from Column G?
This is giving me an error.
If you ONLY want to pull the sum of HR12, then change $A10 to "HR12" (yes with the double quote)
Please Login or Register to view this content.
Yes! This worked!! Thank you so much!!!!!
Your welcome.
And don't forget to mark this thread as 'Solved'
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks