At 19:21 26/01/2012 -0600, Wade Smart wrote:
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?
Yes: =SUMPRODUCT(A1:A99="Black";C1:C99="x")
The conditions are either TRUE or FALSE. When interpreted as
numbers, these values are 1 and 0 respectively. The product gives 1
only if both components are 1, so it effectively ANDs the two
conditions. The resulting true (=1) values are then summed.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
