RMax

As far as I know there isn't any built-in Excel function that will sum
values based upon the colour format of a cell/row.

However, it can be doen with VBA if you won't to take that route. I can do
somehing pretty easily if you wnat that?

Regards


Alex

"RMax" wrote:


I have a spreadsheet that lists each job we have on continuous rows. I
highlight in yellow the rows that contain the jobs that we have not
recieved payment for. Periodically, I print a copy of the spreadsheet
and manually add the 'yellow' jobs together. Is there a formula that
will add the yellow amounts, only? Maybe a 'sumif' function? Thanks.


--
RMax
------------------------------------------------------------------------
RMax's Profile: http://www.excelforum.com/member.php...o&userid=34605
View this thread: http://www.excelforum.com/showthread...hreadid=543775