writing a formula for colored info

A

aaronwexler

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
 
R

Rick B

This is an Access newsgroup. You seem to be asking an Excel question, not
an Access question.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use TODAY() function as the criteria in a SUMIF formula 1
Drop down list control value in vba 2
writing a formula for a colored value 11
Pasting a cell into bookmarked table from excel vba 1
Match table shading (color) to Visio color/Transparency 1
VBA Coding Help for Beginner 0
Excel does not accept text format! 0
Formating bolded text exclusively. 0

Top