Results 1 to 6 of 6

Checking for multiple values

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-23-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    346

    Checking for multiple values

    Evening,

    I am using this formula:

    =SUMPRODUCT(('FFTA25%'!$U$2:$U$180="5a")*('FFTA25%'!$AC$2:$AC$180="C-"))

    This allows me to add up how many time C- is in the column AC, if 5a is in the column U as well.

    What I would like to change it to is count how many times C- or C or C+ is in column AC, if 5a is in column U as well.

    Any help would be greatly appreciated.

    Many thanks
    Last edited by Cmorgan; 01-13-2013 at 02:11 PM.

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