Aaron,

Instead of coloring the cell, put a 1 in the cell next to the value, then use SUMIF:

=SUMIF(A1:A100,1,B1:B100)

will sum the values from B1:B100 where the corresponding value in A1:A100 is 1.

For the count of negative, use

=COUNTIF(B1:B100,"<0")

You could format column A to hide the numbers (or make it very narrow) and still use the yellow to
highlight, for prinouts etc.

HTH,
Bernie
MS Excel MVP


"aaronwexler" wrote in message
...
I have a question about how to write a formula to include specific info in a
range of cells. I have a range of cells I want to include in a formula but I
want the formula to only include the values that I have colored Yellow. I
could select each yellow one by hand but I want this formula to work for data
I continue to add in the future which is way I want to have a large selection
of cells. So for example if I want the sum of all the yellow values in this
range =SUM(C2:E65536) how could I write the formula to do that?

I would also like to write a formula that would count only the negative
numbers. For example in the range =COUNT(C2:E65536) how could I write the
formula to only include the negative or possitive numbers?

Thanks Aaron