Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2009
    Posts
    10

    Unanswered: Count Multiple Columns

    I cannot figure this out for the life of me. I have three columns that need to be looked at. I attached the spreadsheet that I am trying to figure out. Notes are in speadsheet. Thanks in advance for all the help.
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116
    try this

    =SUMPRODUCT(--('FIRE ALARM DEVICES'!$A$8:$A$433=$A19),--(RIGHT('FIRE ALARM DEVICES'!$B$8:$B$433,2)=TEXT(C$18,"00")),--(LEFT('FIRE ALARM DEVICES'!$D$8:$D$433,2)=TEXT($B19,"00")))

    copy formula over and down
    texasalynn
    It's AWL Good!

  3. #3
    Join Date
    Jul 2009
    Posts
    10
    Thank you for the help and the formula. I do have oen question though:

    Becuase I am still new at figuring the formulas and how to manipulate them, Is this formula one formula or is it in sections?

    Thanks

  4. #4
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116
    it is one formula
    texasalynn
    It's AWL Good!

  5. #5
    Join Date
    Jul 2009
    Posts
    10
    Thanks for all of your help.

Posting Permissions

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