Sumif(criteria) need help

T

theslaz

All I want to do is total the value of cells that are hi-lighted in a
certain colour. In other words; I have set up my spreadsheet that when I
have a outstanding/not paid invoice; the value for that cell's background
color is red. I would like to have the spreadsheet add up/total all these
"red" cells.
 
F

fatturtle

you could write a macro to find the 'red' cells and add them (I don't
have that handy)

otherwise use the same criteria you use to turn the cells red in a
formula to return the value, otherwise zero - then sum the column

if you're dead set on a sumif formula, use that criteria to flag the
record as 'Unpaid' and =sumif(A:A,"Unpaid",B:B) with column A being the
new flag and column B being the invoice amount
 
T

theslaz

Thanks for your reply. I think that I will try a macro as that is the
easiest for me.
 
Top