counting colored cells in numbers

S,

You must begin by using Conditional Highlight to color your cells. Don't do it manually. Saying that another way, if you want to do anything with the color information, the colors must be determined by some condition in the cell where they appear. Then you can use that same condition to determine which cells are counted or summed.

Jerry

Smothin wrote:

Hi Jerrold

I just mark them. I could use a color, make them bold or whatever (manually), to make distinction between paid and unpaid.

Greetings

Smothin

My suggestion would be to add a column for Date Paid. If a row has content in Date Paid, include it in the SUMIF spec.

If Date Paid is in Column C, the expression for the conditional sum would be:

=SUMIF(C, "", B)

Jerry

There are no Numbers functions that can detected, and count, shaded cells. You could use an Applescript. If there are conditions that shaded the cells (using conditional formatting) then perhaps you could count those conditions. Sharing more specifics about your situation would aid in helping you.

Try

=SUMIF (C2:C9, TRUE , B2:B9)

Hi Smothin,

It's clear what you want to do. How do you decide which payments to mark?

Jerry

Hi Smothin,

A simple approach might be to add a column with a checkbox. When you are paid you check the box.

Then you could total your paid amounts with SUMIF(checkbox column,TRUE,value column)