Edit the formula (F2), and then commit with Ctrl-Shift-Enter

--
HTH

Bob Phillips

"Thomas Grassi" wrote in message
...
Office XP Pro SP3 Excel I have this in my spreadsheet and I gett #VALUE in
the cell I believe I had to hit a CTRL and some letter before but I do not
remember what it was any ideas?

=SUM(IF((J2:J41="V")+(J2:J41="M"),I2:I41))

#VALUE! ####### #VALUE!



Thanks

Tom