Oops, I forgot to mention, if you type the formula as I wrote it;
=SUMPRODUCT(--($G9:$AS9<=BV$3)*($G$9:$AS9>0),$G$4:$AS$4) and then
press Ctrl+Sfit+Enter, Excel automatically adds the braces {} to
denote an array formula. DO NOT type them yourself, or it will be
interpreted as text...
On Oct 13, 9:22 am, Sid Guevara <[email protected]> wrote:
> Dear Shantanu,
>
> Siti Vi is quite right, you do need Ctrl+Shit+Enter to enter the array
> formula. Also, you could simplify your formula a little by using a
> double minus for the SUMPRODUCT, and do away with the IF. Minus minus
> (--) converts SUMPRODUCTs TRUE/FALSE values to 1s and 0s. So you get:
>
> =SUMPRODUCT(--($G9:$AS9<=BV$3)*($G$9:$AS9>0),$G$4:$AS$4)
>
> Hope this helps,
>
> Sid.
>
> On Oct 12, 7:59 am, shantanu chouhan <[email protected]>
> wrote:
>
> > Dear all experts
>
> > i am using a sheet where a cell containg a formula
>
> > cell:{=SUMPRODUCT(IF(($G9:$AS9<=BV$3)*($G9:$AS9>0),1,0),$G$4:$AS$4)}
>
> > where if i duble click or delete this sign {} the out come is
>
> > cell:#VALUE!
>
> > shatanu
> > please help me out
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to [email protected]
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
