writing a formula for colored info

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
This is an Access newsgroup. You seem to be asking an Excel question, not
an Access question.
 
Back
Top