Excel Newbie Question Please Help

[Thomas Grassi]

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

 

[Bob Phillips]

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

 

[Dave Peterson]

Try ctrl-shift-enter.

Another way without the ctrl-shift-enter:

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

 

[Zack Barresse]

Hello Thomas,

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

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

 

[Thomas Grassi]

Thanks

It worked

Tom

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