Need Help

  • Thread starter Thread starter Skegee
  • Start date Start date
S

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!!!!!!
 
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)
 
Back
Top