+ Reply to Thread
Results 1 to 4 of 4

Question about IF/THEN

  1. #1
    Registered User
    Join Date
    05-23-2007
    Posts
    6

    Question about IF/THEN

    Ok - I hope I can explain this

    I want to be able to count how many rows of data have this information:

    If I have 100% in column A and I have the letter Q in column C

    Somethink like If A2=100 and C2=Q then E2=1....and then count all of the data in column E up (???). So if A2 didn't =100 or C2 didnt equal Q then the cell in column E would be zero.

    Sorry if this is confusing.

  2. #2
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Lets assume you have 100 rows of data:

    =SUMPRODUCT(--(A1:A100=100),--(C1:C100="Q"))

    Let me know if that works

  3. #3
    Registered User
    Join Date
    05-23-2007
    Posts
    6
    Thank you! That worked perfectly. I could not find in that in the "help" section anywhere. THANK YOU!

  4. #4
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Glad I could help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1