Excel

A

Alison

Now, this is probably either really easy, or totally
impossible!

Can I, in Excel, add up everything that is one colour,
i.e. paid bills are black unpaid are green and overdue
are red. Is there a formula to say "please add up all
the black ones only?" I'm using Excel 97 SR-1
Ta!
Alison
 

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

Excel 2010 Conditional Formatting 2
Help with conditional formatting in Excel 2010 8
IF Function formula (I think?) 4
I need help with excel IF function 2
=sum 5
Conditional Formatting - Cannot get it to work, please help 1
IF Lookup Formula 2
Conditional Sum Based on Cell Background Color 6

Top