Check out our brand new Local Poker Communities! Get updates and interact with poker players in your area.
Visit the United States Poker Community | Visit the California Poker Community | Read more about the Launch of P5s Local

Excel Question

Reply to Thread
  1. frickensweet frickensweet is offline

    Des Moines, IA
    United States

    Posts: 797
    Joined: Mar 06

    Sep 18th, 2007 (9/18/2007 2:33pm)

    I need a formula that tells me how many times two seperate columns in the same row = false

    I.E. In this situation the answer would be 4 because false shows up in the same row in two seperate columns

    <TABLE cellSpacing=0 cellPadding=0 width=284 border=0 x:str><COLGROUP> <COL width=94> <COL width=66> <COL width=65> <COL width=59> <TBODY><TR height=17><TD align=right width=94 height=17 x:num>200128577</TD><TD align=right width=66 x:num>5408</TD><TD align=middle width=65 x:bool="TRUE">TRUE</TD><TD align=middle width=59 x:bool="FALSE">FALSE</TD></TR><TR height=17><TD align=right height=17 x:num>140085598</TD><TD align=right x:num>5408</TD><TD align=middle x:bool="FALSE">FALSE</TD><TD align=middle x:bool="FALSE">FALSE</TD></TR><TR height=17><TD align=right height=17 x:num>140085598</TD><TD align=right x:num>5408</TD><TD align=middle x:bool="FALSE">FALSE</TD><TD align=middle x:bool="FALSE">FALSE</TD></TR><TR height=17><TD align=right height=17 x:num>140085598</TD><TD align=right x:num>5408</TD><TD align=middle x:bool="FALSE">FALSE</TD><TD align=middle x:bool="FALSE">FALSE</TD></TR><TR height=17><TD align=right height=17 x:num>221433063</TD><TD align=right x:num>5408</TD><TD align=middle x:bool="FALSE">FALSE</TD><TD align=middle x:bool="FALSE">FALSE</TD></TR></TBODY></TABLE>

    Thanks for your help all
  2. cruizr cruizr is offline

    Vanuatu

    Posts: 3,674
    Joined: Jul 06

    Sep 18th, 2007 (9/18/2007 2:35pm) in reply to frickensweet

    Start column E.

    In cell E1 - @if(c1=d1,1,0)
    In cell E2 - @if(c2=d2,1,0)
    etc.

    Total up column E.

    Crude, but effective.
  3. frickensweet frickensweet is offline

    Des Moines, IA
    United States

    Posts: 797
    Joined: Mar 06

    Sep 18th, 2007 (9/18/2007 3:09pm) in reply to cruizr

    Thanks for the idea Cruzr!

    Thats very close to what I am looking for but I'm looking for something a little smoother then that.

    Any other ideas?
    Thread Starter
  4. Mike_Hawke Mike_Hawke is offline

    Fort Worth, TX
    United States

    Posts: 999
    Joined: Jul 06

    Sep 18th, 2007 (9/18/2007 3:14pm) in reply to cruizr

    That doesn't work, because it will return a "1" when both conditions are true.

    I would suggest using the AND function.

    So, in Cell E1: =AND(C1="FALSE", D1="FALSE")

    This will return "TRUE" if the values in both C1 and D1 are false. (The AND function returns the word true when both conditions are met.)

    Lastly, you can do a Countif in some other cell to count the number of "TRUE"s in column E.
  5. cruizr cruizr is offline

    Vanuatu

    Posts: 3,674
    Joined: Jul 06

    Sep 18th, 2007 (9/18/2007 3:47pm) in reply to Mike_Hawke

    HA! You're right Mike - hadn't considered that.
Reply to Thread

Similar Threads