A non-VBA approach would be to add a new column, and then use that column to
enter an "X" for any rows that you want to highlight. You can use
Conditional Formatting in your "Job" column to create the highlight. Then,
you can use SUMIF to get your total of "highlighted" jobs by checking the new
column for the presence of an "X".

For example, lets say your Jobs are stored in Column A, and amounts in
Column B. You would add a new column C, and enter an "X" for any rows that
should be highlighted.

Select colummns A and B, then from the Format Menu, select Conditional
Formatting. Change "Cell Value Is" to "Formula Is" and enter the formula:

=$C1="X"

Then choose your formatting (yellow background). Click OK. Now the
appropriate rows should highlight automatically.

Then for your total, use this formula:

=SUMIF(C1:C100,"X",B1:B100)

You should now have a total of all cells in column B that are highlighted.

HTH,
Elkar


"RMax" wrote:


I'm not familiar with VBA. However, I'm open to all options. Thanks.


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