Below is the formula I am using. In the first part of the formula where I am looking for values beginning with BCDF I want to be able to reference a cell with the value BCDF typed into it - Like =SUMPRODUCT(--(LEFT(DATA!$C$1:$C$1850,4)="A1") - where A1=BCDF. IS THIS POSSIBLE????
=SUMPRODUCT(--(LEFT(DATA!$C$1:$C$1850,4)="BCDF"),--(LEFT(DATA!$D$1:$D$1850,4)="CONT"),DATA!$J$1:$J$1850)
Last edited by NMJones; 09-09-2009 at 05:39 PM.
You only put quotes around text strings, not cell references.
=SUMPRODUCT(--(LEFT(DATA!$C$1:$C$1850,4)=A1), --(LEFT(DATA!$D$1:$D$1850,4)=B1), DATA!$J$1:$J$1850)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks