countif on multiple items

Wade Smart <[email protected]> Thu, 26 Jan 2012 19:21:57 -0600

Newsgroups	gmane.comp.openoffice.questions
Message-ID	<CAK3k1ZHYZZGRfsVmLZFY7uDN35v0n5Meu9MJmnDXQvEGeeKO3Q@mail.gmail.com>

I need a total based on two columns.

For example:

A1 = Black
A3 = Dk Blue
A9 = White

C1 = x
C3 =
C9 = x

If a1=Black AND c1 = x then count this as one.

Can you count if with two columns?

Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
-- 
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help