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

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

Try ctrl-shift-enter.

Another way without the ctrl-shift-enter:

=SUMPRODUCT((J2:J41={"V","M"})*I2:I41)



Thomas Grassi wrote:

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

--

Dave Peterson

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

Thanks

It worked

Tom

"Bob Phillips" wrote in message
...
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