i'd set the excel up so that you have in Column A the Job Undertaken
then the next columns the name of the job.
Column A ColumnB Column C
Job Undertaken, Walk Groom etc

In COlumn A you woudl enter what job was done,

in Coumn B, =IF($A2="Walk","$10","$0")
in Column C, =IF($A2="Groom","$15","$0")

Then Fill them down, so in each column a value would appear dependant
on what was entered into Column A. You Sum them at the bottom then
without having to do a pivot table.


--
samprince
------------------------------------------------------------------------
samprince's Profile: http://www.excelforum.com/member.php...o&userid=34168
View this thread: http://www.excelforum.com/showthread...hreadid=567383