+ Reply to Thread
Results 1 to 2 of 2

Configuring SUM formula to include or exclude certain characters?

  1. #1
    Registered User
    Join Date
    02-08-2008
    Posts
    4

    Configuring SUM formula to include or exclude certain characters?

    Hi all,

    I have a spreadsheet to keep track of my record company's sales. We're tallying both units sold and dollar amount (the latter of which may vary depending on where an album is sold to).

    Attached is a screenshot of the format that I have going right now. I realize that there are better ways to lay out this information, but right now I'm not looking for suggestions on more efficient ways to manage the data.

    What I'm looking for is one of the following: A way to take a sum of a column and have that sum only include odd or even numbered rows. Or a way to sum a column and include or exclude cells based on the formatting (a presence or lack of the $ symbol). Or some other way.

    Any help is very much appreciated!
    Attached Images Attached Images

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    =SUMPRODUCT( (MOD(ROW(A1:A10), 2) = 0) * A1:A10) (even rows)

    =SUMPRODUCT( (MOD(ROW(A1:A10), 2) = 1) * A1:A10) (odd rows)

+ 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