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!

=SUMPRODUCT( (MOD(ROW(A1:A10), 2) = 0) * A1:A10) (even rows)

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