Counting items from Table

  • Thread starter Thread starter Growler
  • Start date Start date
G

Growler

Hi,

I've created a table that has a number of columns, eg

Item No Open/Closed Type
122 Open Letter
143 Closed Fax
156 Open Letter
234 Closed Letter
253 Open Fax

And what I want to do is add up the number of items that are open and
of type Letter. i.e

Open AND Letter = 2

I've tried COUNTIF but that only works on one column, so any
suggestion on how I can achieve this. This list will be added to so I
would prefer the sum updates to be done automatically over a larger
range than is currently present.

Thanks in advance for your time.

Cheers

Andy
(e-mail address removed)
 
=SUMPRODUCT(--(B2:B100="Open"),--(C2:C100="Letter"))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
My Pleasure

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top