Vlook-up + ???? formula

[merz]

I am looking for a formula which would find text in cells (vlook-up?), in this case, bn, wh, gv, bl - which are abbreviations for our office locations, and add the number of times it finds those locations (abbrv) for every employee on the list. We designate their locations by the above abbreviations. The abbreviations are in column A. I created column F to be the full name of the location and I would like the total count in colmn G.

In other words if "bn" is entered in several rows throughout the spreadsheet, I would like to count how many times it appears. This gives us a head count for each employee at that particular location.

As always -- thank you!

 

[taigovinda]

It sounds like you may want some kind of countif() or sumproduct (or countifs() if you have 2007 or above)... Can you provide a small sample of what the data looks like and what the desired result should look like?

 

[merz]

See below for a sample of the spreadsheet. Location is Column A, Last Name B, First Name C. As I explained in my previous post, in Column G I want the total count of employee's on individual rows for each location. There are four. I more or less, want to put in a formula to look for CV, CN, BL, and WH, on all the rows of the spreadsheet, and put the totals in.

Location Last Name First Name
CV
CN
BL
WH

 

[merz]

PS. I have Excel 2003. Thanks for your assistance.

 

[taigovinda]

So... for CV you only need:

=countif(A:A,"CV")

...which in the sample from post #3 would return 1 (CV shows up just once).

Maybe I'm missing something here; if there's more to it, please post a small sample that includes all the fields (at least the ones needed to evaluate the formula) and the desired result of the formula.

 

[merz]

To: taigovinda --

OMG! You are just awesome!!!! It worked beautifully!!!! Was the formula really that easy - duh? And here I thought

Everyone who provides assistance on this site is just so fabulous! What would we do without you. Give yourself a BIG {{{hug}} for me

Do you also provide assistance on another site for Word, Outlook, etc. as well? Just in case the need should arrive.

Have a super day and a most fabulous weekend, because I wish it so.

 

[taigovinda]

Hi Merz, glad it worked!

I've gotten help on here with using Excel to automate Word and Outlook... not sure what would be the good sites that specialize in those as I don't use them too much... Happy computing!

Tai