Excel Newbie Question Please Help
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
|