Just to add to NBVC's response.

I'd put those amounts in B1:D1 (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.



NBVC wrote:

Say your first set of X's can be entered in B2:D2 with headers, A,B,C in
B1:D1 and Dates starting at A2, downwards...

So then in E2, enter formula:

=SUMPRODUCT(--($B2:$D2="X"),{500,350,200})

copied down...

--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=109619

--

Dave Peterson