Right - I'll need a bit more info, please:

Using your uploaded test sheet as an example - in the worksheet 'TECH ONLY' what exactly is it that you want to add up - can you tell me the exact column and word based on your workbook!


Bird

it's to only add up how many rows that column has something in it. so if there are 50 rows, and only say 20 has something in that column then the total would be 20.

So you are only looking to count if there is ANYTHING in the row - OK

Type [=COUNTA(] (without [] brackets) and then go to the worksheet you want and select the range then type[)] and enter

COUNTA function will count all the cells and return the number that contain data

Using the example sheet that you uploaded the PRW Only total box would contain the following formula if it were counting all the Sales Person column in the TECH ONLY worksheet:

If you are looking to count a particular word, not ANY data, this will need to be COUNTIF instead and would look like this:

If you were looking for how many times the name Phil were to appear in the First Name column on the TECH ONLY worksheet...

Is that any help?



BTW - in PRW ONLY STATS cell F8 you should use a range operator, rather than individual cells when using =SUM - only when the cells are not next to each other do you need to revert to x+x+x+x

ie. =SUM(B8:E8) is the same as =(B8+C8+D8+E8)

in the second example you don't need SUM because you are using the + symbol which is what =SUM means!

Welcome to the fun world of Excel formulas - just wait till BODMAS comes along to bite you - LOL!

Thank you BIRD. Sorry I got the responce a week ago via email, and then my email crash, and I belong to some many MSOffice Forums that I forgot which forum I was in when I recieved this posting. But I will try out your formula and give you a responce back asap. Once again thanks!

Hey BIRD, there's been another change in the plan. I wish my Supervisor would just make up their minds how they want this done, so that I can be done with it. So here's the problem

They want a formula that will total on which officer has pend in on cell and which officer has techs in another.

example: officer joe has 12 tech and 20 pending
officer john has 20 tech and 10 pending
officer doe has 50 tech and 20 pending

SHEET#1
colm #A will be officer name, colm #B will have the word tech or pend beside the officer row that the data is enter. On SHEET#2 the STATS will refect the total # of tech and a total # of pend for each officer.