Excel Newbie Question Please Help
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 |
Excel Newbie Question Please Help
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 |
Excel Newbie Question Please Help
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 |
Excel Newbie Question Please Help
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 |
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 |
All times are GMT +1. The time now is 10:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com