Need Help

[Skegee]

I'm working on a spreadsheet with multiple columns. Column A has
names/descriptions and column B has whether they are above, below or on
plan.

My question is I want to use a function (like a CountIf with a nested
AND) to count the number of times a name shows up in column A and is
above plan.

I bet it's something very simple but I can't seem to figure it out and
it's been 3 hours since I started messing around with this. HELP!!!!!!

 

[Bob Phillips]

Skegee,

Something like

=SUMPRODUCT((A1:A100="description1")*(B1:B100="aboveplan"))

just put your values in

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)