Lookup and count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=SUMPRODUC(--(N2:N200="Jaco Jacobs"),--(E2:E200="Service Desk"))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup and Count Continued 2
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Lookup help 1
lookup 1
Multiple conditions 3
Locate text in range (multiple occurrences) and report other cell insame column? 10
***Help on writing a vba code 12

Back
Top