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