+ Reply to Thread
Results 1 to 3 of 3

Counting different criteria in different columns ??

  1. #1
    Registered User
    Join Date
    07-08-2009
    Location
    sydney, australia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Counting different criteria in different columns ??

    Hi
    I need to count different criterias from different columns. I have been tryiing to work with array formulas but I just can't string it together. Also, in one of my columns some cells have only part of the criteria.

    Column A - has either Australia Post , express, express post, Exp
    Column B - has 24g, 24f, or 24t

    I need a formula that will count all "Express" types (i.e express, express post and Exp)if it also has 24g in column B .

    Hoping someone can help

    snowee01
    Last edited by snowee01; 07-10-2009 at 09:18 AM.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,607

    Re: Counting different criteria in different columns ??

    Try this:

    =SUMPRODUCT(--(LEFT(A1:A12;1)="E");--(B1:B12="24g"))

    (replace ; with , if needed)

  3. #3
    Registered User
    Join Date
    07-08-2009
    Location
    sydney, australia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Smile Re: Counting different criteria in different columns ??

    thank you, you did it

+ 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