RE: To Count or not to Count

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hey Greg,
Try this shot of penecilin. In this example Planned Position is in column
B11, Assigned Position is in column C11, Hours Assigned in Column S12. First
formula is in cell B10 and the other in C10. As the Dr. will say, "Take this
medicine and I wil call yo in the morning". :)

Jan =COUNTA(B12:B19) =COUNTA(C12:C19) Column S
Column A - Planned Position Column C - Assigned Position
40
Row 1 - Lead Chicken Plucker
20
Row 2 - Feather Sweeper
10
Row 3 - Beak Tweeker
30
Row 4- Assistant Beak Tweeker

--
tech1NJ


"Greg in CO" wrote:

I have a resource planning ***. In column A, I have a drop menu which
allows the user to select a job position which the think they may need. In
column S, they can put the estimate hour for that job. Column S is for
January.
I would like to count the entires in column S which equate to an entry in
column A. I have tried countif, counta, nested if formulas...I am stumped.
The logic should be "if there are entries in column A, count the
corresponding entries in column S. Also, there is the same drop menu in
column C, which allows the user to indicate that they have an actual resource
with the desire job position assigned, and then the estimate or actual hours
for that assigned resource would also go into column S (or for in the column
for the month in question). So, column S could have entries for planned
resources and for assigned resources.

Any help is appreciated...my brain hurts at the moment.
.

Quantcast