Results 1 to 4 of 4

Sumif, sumifs, counta, countifs??

Threaded View

  1. #1
    Registered User
    Join Date
    06-12-2009
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2010
    Posts
    68

    Sumif, sumifs, counta, countifs??

    I have the following table:

    COL A COL B
    Blue 5
    Red 3
    Yellow 2
    Green 1
    Yellow 1
    Red 4
    Yellow
    Blue 6
    Purple 3

    I need to count the number of times COL B has a number or data in it (any number it doesn't matter) if COL A has the word Yellow next to it. So in my example above, Yellow would result in 2, Purple 1, Blue 2, etc. I cant work out how to do this, i think it needs some sort of nested SUMIF, COUNTA formula but cant work out what?

    Many Thanks
    Last edited by 1.zer0; 01-14-2012 at 06:17 AM.

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