Re: This Formula does not work....
From: Tushar Mehta (tmUnderscore200310_at_tushar-mehta.SeeOhEm)
Date: 05/05/04
- Next message: Jackie O'Brien: "Excel 2000"
- Previous message: Mark Graesser: "RE: Finding Highest Value"
- In reply to: Gunjani: "Re: This Formula does not work...."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 05 May 2004 13:53:57 GMT
You have to know the subtleties in how SUM works. It ignores
everything that is non-numeric. Your formula generates an 249 element
boolean array. SUM ignores booleans! Also, since the formula
generates an array, you would have to use an array formula to get SUM
to work with that array. So, array enter =SUM(N($D$1:$D$249="R")) and
it will work.
To array enter a formula use CTRL+SHIFT+ENTER to complete formula entry
rather than the usual ENTER.
-- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article <MPG.1b02e84bf43760f69896ba@news.btinternet.com>, yunus786DELETETHIS@btopenworld.com says... > In article <4098d561$0$566$e4fe514c@news.xs4all.nl>, akyurek@xs4all.nl > says... > > =COUNTIF($D$1:$D$249="R") > > > > =COUNTIF($D$1:$D$249=J16) > > "Gunjani" <yunus786DELETETHIS@btopenworld.com> wrote in message > > news:MPG.1b02e1d1663db0a69896b8@news.btinternet.com... > > > I'm trying to Count the amount of 'R' appearing in column D. Tried this > > > formula below but no joy. > > > > > > =SUM($D$1:$D$249="R") > > > > > > Also tried =SUM($D$1:$D$49=J16) where J!^ contains letter R but still no > > > joy. > > > -- > > > Many Thanks > > > > > > Gunjani > > > Under the bed is not a good place to save snowballs for > > > summer. > > > > > > > Thank you. Only worked when the = is replaced by a , sign. But why cant > the original SUM formula work? >
- Next message: Jackie O'Brien: "Excel 2000"
- Previous message: Mark Graesser: "RE: Finding Highest Value"
- In reply to: Gunjani: "Re: This Formula does not work...."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
