Results 1 to 8 of 8

How to sum the totals on one column, if two other columns are true?

Threaded View

  1. #1
    Registered User
    Join Date
    08-17-2008
    Location
    Worthing, Sussex, UK.
    Posts
    46

    How to sum the totals on one column, if two other columns are true?

    Hi.

    (Excel 2003 on windows XP.)

    I need to SUM the cells in column J when column E has the word "yes" and the range N:R has a letter "w" in one of the columns. Only one of the N:R columns will have an entry on any one row and it may not necessarily be a "W".

    I have Googled, and being a beginner I don't comprehend the result! Some people were talking about using an add in, but I won't be allowed to add software to our PC's. Could someone give me a pointer to the correct function please?

    An example of some data...

    A B . .  E  . J  . N O P Q R
    x x . . Yes . 12 . . . . w .
    x x . . No  . 3  . . . . w .
    x x . . Yes . 1  . . . . . a
    x x . . Yes . 5  . w . . . .
    Thanks in advance.
    Last edited by Simon Lloyd; 10-03-2008 at 06:39 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