Hello Thomas,

This is an Array Formula. Chip Pearson describes them very well on his site
....

http://www.cpearson.com/excel/array.htm


--
Regards,
Zack Barresse, aka firefytr

"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