On Thu, Jan 26, 2012 at 20:07, Brian Barker <[email protected]> wrote: > 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 send email to [email protected] > For additional commands send email to [email protected] > with Subject: help
Great! Thanks for that Brian :D -- 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
