Finding the difference

[Renegade]

I am working in Excel XP, and I have a spreadsheet with raw data. In the
rows are listed items purchased and in one column, the total cost of all
items purchased. At the end of that column is the grand total of all items
purchased. Some of the items listed in the rows are highlighted in Yellow.
I need a formula that will extract only those items that are highlighted in
yellow, and provide a subtotal of only the items that are not highlighted in
yellow. Because this list is rather lenghty, Excel did not appear to like my
selecting individual items to sum. Any assistance would be appreciated.

 

[Luke M]

Rather than highlighting in yellow (XL can't detect colors!) use a helper
column (say, Z) and mark the rows you want with an "X" (or use a
formula/crtieria as to why those rows are marked yellow). Then you can use
the SUMIF function like
=SUMIF(Z:Z,"X",A:A)