J
Jaco Jacobs
What i want to do is lookup on sheet2 column N and if it is the same as
sheet1 column A add it up at the same time as sheet2 column E has a specific
wording.
EG
Sheet 2 will have many entries of Jaco Jacobs under column N
Sheet 2 will also have many entries for Service Desk as well as others in
column E
Sheet 1 will need to count all values that are both Jaco Jacobs under N and
Service Desk under E and return the value.
Please advise if this does not made sense.
Regards
Jaco Jacobs
sheet1 column A add it up at the same time as sheet2 column E has a specific
wording.
EG
Sheet 2 will have many entries of Jaco Jacobs under column N
Sheet 2 will also have many entries for Service Desk as well as others in
column E
Sheet 1 will need to count all values that are both Jaco Jacobs under N and
Service Desk under E and return the value.
Please advise if this does not made sense.
Regards
Jaco Jacobs