Somthing like the below..

Row1 will have the values..A1=500 , B1=350, C1=200 etc;
Row2 will have the x markings
D2 will have the below formula..Copy down as required for the dates...

=IF(A2="x",$A$1,0)+IF(B2="x",$B$1,0)+IF(C2="x",$C$ 1,0)

If this post helps click Yes
---------------
Jacob Skaria


"deertroy" wrote:

I have a small spread sheet set up to keep track of a grass cutting contract.
We have our area divided into sections A-G. Each section has a different
dollar amount attached to it (section A $500, B $350, C $200, etc.) I list
the sections across the top of my spread sheet. Down the side I list the
date. If for instance we have the contractor cut sections A, B and C during
the first date I put and X in cells B2, C2 and D2. I would like to then have
this total $1050. How can I get the cells to read the dollar amount even
though I'm typing an X in each cell?

Thanks