sum numbers of a different colur in a row of data

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

Guest

How do I sum numbers in a row that has different colours. I want to sum
black colours and red colours separately
 
You could try this alternate method which doesn't use VBA.

In 2003 you can specify the Format color to look for under
Edit>Find>Options>Format>Format.

Select the color from the Patterns dialog and Find All.

In the found dialog box the first cell will be highlighted. Hold SHIFT key and
scroll down to bottom of dialog box and select last cell.

The selected cells can then be summed by right-click on Status Bar and "Sum".

Do for each color.


Gord Dibben MS Excel MVP
 

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

Sum if cell = grey 4
Sum by Fill colour 3
Sum macro 2
Function for summing or counting cells based on a specified fill color 2
Alternate row shadding even when rows are hidden 7
Text Colour 5
Counting Cells with Conditional Formatting 7
Using SUM function to count hours BUT ignore Letters? 6

Back
Top