+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, SUMPRODUCT Formula help in Technical; Hello All, Fairly advanced Excel formula help please... I want to count the number of cells in Column B that ...
  1. #1

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0

    SUMPRODUCT Formula help

    Hello All,

    Fairly advanced Excel formula help please...

    I want to count the number of cells in Column B that = "A", "B", "C" IF Column A = "A", "B", "C"

    I can't get a SUMPRODUCT to work with multiple criteria in both columns (or a wildcard in one column).

    I have tried:
    =SUMPRODUCT(--(ColB={"A","B","C"})*(ColA={"A","B","C"}))
    =SUMPRODUCT(--(ColB={"A","B","C"})*(ColA="*"))

    Neither work.

    I could use an intermediate calculation, but I'm trying to avoid it. I could use:
    =SUMPRODUCT(--(ColB={"A","B","C"})*(ColA="A"))+SUMPRODUCT(--(ColB={"A","B","C"})*(ColA="B"))+...

    but that's messy.

    Anyone any ideas? Thanks in advance

  2. #2

    Join Date
    Nov 2006
    Location
    Lancashire
    Posts
    95
    Thank Post
    34
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Hi all,

    solution to this problem is on another forum. SUMPRODUCT Formula help - MrExcel Message Board

    Hope it helps,
    Ben

SHARE:
+ Post New Thread

Similar Threads

  1. Excel Formula
    By Pumaedition in forum How do you do....it?
    Replies: 6
    Last Post: 8th July 2009, 08:52 AM
  2. Formula 1 Tickets
    By FN-GM in forum General Chat
    Replies: 4
    Last Post: 4th December 2008, 08:19 PM
  3. Excel Formula
    By denon101 in forum How do you do....it?
    Replies: 3
    Last Post: 1st December 2008, 03:34 PM
  4. excel formula help again please
    By RabbieBurns in forum Windows
    Replies: 2
    Last Post: 13th August 2008, 05:31 PM
  5. Excel Formula Help
    By DSapseid in forum Windows
    Replies: 4
    Last Post: 7th November 2007, 04:56 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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