Summarise hours incurred by month based on multiple criteria
Solved/Closed
Micwhsct
Posts
7
Registration date
Wednesday 29 May 2019
Status
Member
Last seen
19 August 2019
-
16 Aug 2019 à 10:58
Micwhsct Posts 7 Registration date Wednesday 29 May 2019 Status Member Last seen 19 August 2019 - 19 Aug 2019 à 07:50
Micwhsct Posts 7 Registration date Wednesday 29 May 2019 Status Member Last seen 19 August 2019 - 19 Aug 2019 à 07:50
Related:
- Summarise hours incurred by month based on multiple criteria
- Linkedin learning cost per month - Guide
- How to change account based in instagram - Instagram Forum
- Fnia after hours download - Download - Adult games
- How to delete multiple files on mac - Guide
- Can you log into instagram on multiple devices - Instagram Forum
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.
19 Aug 2019 à 05:46
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.
19 Aug 2019 à 07:46
19 Aug 2019 à 07:50
I'm not as smart as I thought on excel - but at least I try.