Summarise hours incurred by month based on multiple criteria
Solved/Closed
Micwhsct
Posts
7
Registration date
Wednesday May 29, 2019
Status
Member
Last seen
August 19, 2019
-
Aug 16, 2019 at 10:58 AM
Micwhsct Posts 7 Registration date Wednesday May 29, 2019 Status Member Last seen August 19, 2019 - Aug 19, 2019 at 07:50 AM
Micwhsct Posts 7 Registration date Wednesday May 29, 2019 Status Member Last seen August 19, 2019 - Aug 19, 2019 at 07:50 AM
Related:
- Summarise hours incurred by month based on multiple criteria
- How to delete multiple files on mac - Guide
- Allow multiple downloads chrome - Guide
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Photoshop multiple selections - Guide
- Forex hours app for pc - Download - Finance
1 response
Is time-converted a named range?
What value is in cell B5 that you are trying to match?
Not only that, but the syntax of match is as follows:
MATCH (LOOKUPVALUE, LOOKUPARRAY, MATCHTYPE).
Your match is summing on the second lookuparray. So your array is not constructed correctly, as it should be in the form of cellAdress1:cellAdress2.
What value is in cell B5 that you are trying to match?
Not only that, but the syntax of match is as follows:
MATCH (LOOKUPVALUE, LOOKUPARRAY, MATCHTYPE).
Your match is summing on the second lookuparray. So your array is not constructed correctly, as it should be in the form of cellAdress1:cellAdress2.
Aug 19, 2019 at 05:46 AM
B5 represents a specific grade of staff within the named range 'Grade'.
A B C D E
5 XR02 Other SCOT G Total Hours
6 Apr #N/A 0 0 #N/A
7 May 0 0 0 0
8 Jun 0 0 0 0
To clarify what I want to do is look for a specific grade of staff within the named range 'Grade' and then sum total hours related to that month from the time_converted column.
This is an extract of the main data source tab named ranges needed for the formula.
J P Q R S
10 Grade Cost Cente Time Converted Agency Mth
11 XR02 E0A072 10.75 Other Apr
12 XR02 E0A072 10.75 Other Apr
13 XR05 E0A072 10.75 SCOT G Apr
14 XR05 E0A072 10.75 SCOT G Apr
15 XR02 E0A072 8.5 Other Apr
Thanks again.
Aug 19, 2019 at 07:46 AM
Aug 19, 2019 at 07:50 AM
I'm not as smart as I thought on excel - but at least I try.