Combine vlookup and countif formulas

**StrydomM** · 05-28-2013, 05:42 AM

Hi Guys

I need to combine or find a formula that can lookup and count information required.

This one is a bit tough as some of the info will be difficult to look up.

I've attached an example doc, but here's what i need to do.

1. I need to find all the "persons" on one sheet that fall within a certain class for example "printers"
2. I need to count how many "printers' there are under one persons name.

The detail is in one sheet, and I need to do the formula in a second sheet.

If anyone can assist, i'd be very greatful.

**StrydomM** · 05-29-2013, 01:37 AM

Hi Again

i'm still struggeling with this formula.

I've tried a few different options such as combining a countif and match formula, i've tried a sumproduct and none of these work out, i get all kinds of errors!

Please, if anyone has some advise, i believe i'm overthinking this a tad, but don't know what else to do.

PLEASE HELP

**Craig K.** · 05-29-2013, 09:31 AM

Which tab are you trying to grab information from and which tab are you trying to put information into? It's easier for us when you use the field & tab names that are in the file.

**StrydomM** · 05-30-2013, 01:19 AM

Hi Craig

If you look at the test document I attached, the second sheet call employee asset list. Columns K to V is where I need to calculate the total "pinters" there are under each persons name. In the first sheet you will see that there is a breakdown of each of these itmes which are allocated to certain persons. So from the 1st sheet I will be taking information from

Column A and Column Q

I hope this makes sense

**Craig K.** · 05-30-2013, 09:55 AM

It's a very weird setup you have on the Asset Register tab. But here's my stab at what you're asking for...

In column A of the Asset Register tab, fill in all the blanks under the item headers (ex. copy down the word "printer" in rows 4&5, "Monitors" in rows 7&8, etc.)
In the Employee Asset Register tab, update cell K2 to say "Printers"
In the Employee Asset Register tab, in cell K3 put the following formula in
Formula:
```
Please Login or Register  to view this content.
```
copy the above formula down and across.