Thanks Peo, but that did not quite work. It returned a result of "0", even
though A12 and S12 both had entries...so it should have counted S12 as "1".
Here is the formula with my actual ranges (FYI, Excel said there was a parens
missing from the one you posted):

=SUMPRODUCT((A12:A34<""),--(S12:S34<""))
--
Greg


"Peo Sjoblom" wrote:

=SUMPRODUCT(A2:A50<""),--(S2:S50<""))

--


Regards,


Peo Sjoblom

"Greg in CO" wrote in message
...
Close, but no cookie. The COUNTA formulas work fine, but do not reflect
the
realtionship between an entry for a Position and that position having
hours
in Jan.

Let me try explaining the data again.

Column A has a list of Planned Positions
Column S is where the user enters the planned hours for the month of Jan
(Column T is Feb, etc.)

I am trying to find a formula that will look at Column A and confirm it is
not blank, and then go across on the same row and count the non-blank cell
on
Column S.

The end goal is "How many Planned Positions have hours in Jan?" I am not
looking for a sum of the hours, but a count of the hours entries for Jan
for
Planned Positions. Using the positions I posted earlier:

Column A Column S (Jan)
Lead Chicken Plucker 40
Feather Sweeper 20
Beak Tweeker 10

I would have the following results: 3 planned resources have hours in Jan.

This is important as, should there be an entry in Column a, but there are
no
hours in Column S, then that resource would not be counted as having hours
in
Jan.

If anyone is game for me to email them a copy of this sheet, i am happy to
do so. I looked at the SUMPRODUCT site in the UK - great info, but I
didn't
see a formula which solved the problem.....at least from what I could see.

Again, any help is appreciated.

--
Greg


"tech1NJ" wrote:

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 sheet. 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.