Having a cell show X but read something else?

[deertroy]

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

 

[Jacob Skaria]

Just now I realised you have more sections. If your x markings are from A to
G with row1 having the values...try the below formula in H2; and copy down as
required...

=SUMPRODUCT(--(A2:G2="X"),$A$1:$G$1)

If this post helps click Yes

 

[Dave Peterson]

Just to add to NBVC's response.

I'd put those amounts in B11 (or maybe a hidden row. Then the formula
becomes:

=SUMPRODUCT(--($B2:$D2="X"),$B$1:$D$1)

Then if your prices change (next year's spreadsheet???), you'll only have to
update the new prices in that row.

 

[deertroy]

Used NBVC method. Exactly what I was looking for. Thanks to all.

 

[deertroy]

I just read Dave's post so I used his modified formula to save me time next
year. Thanks again