Using wildcards w/ sumproduct

  • Thread starter Thread starter Julz
  • Start date Start date
J

Julz

I'm not familiar with wildcards in formulas, and I can't seem to figure
out exactly what to do here.

If the first 3 letters in cells of column A contain FPC, then sum
corresponding rows in column P, then by the total number of cells in
column AT where the first 3 letters are FPC.

=SUMPRODUCT((LEFT(A1:A20014,3*(closed!$A$3:$A$20003="FPC"))),(closed!$P$3:$P$20003)/SUMPRODUCT((LEFT(A1:A20014,3*(closed!$AT$3:$AT$20003="FPC")))))


Any assistance is greatly appreciated.
Thanx,
~Julz
 
Hi
if I understood you correctly try
=SUMPRODUCT(--(LEFT(closed!$A$3:$A$20003)="FPC"),closed!
$P$3:$P$20003)/SUMPRODUCT(--(LEFT(closed!$A$3:$A$20003)
="FPC"))
 
Both LEFT functions need to specify 3 characters

=SUMPRODUCT(--(LEFT(closed!$A$3:$A$20003,3)="FPC"),closed!
$P$3:$P$20003)/SUMPRODUCT(--(LEFT(closed!$A$3:$A$20003,3)
="FPC"))

Jerry
 
Jerry,

That did the trick!!

Many thanx!
~Julz
Both LEFT functions need to specify 3 characters

=SUMPRODUCT(--(LEFT(closed!$A$3:$A$20003,3)="FPC"),closed!
$P$3:$P$20003)/SUMPRODUCT(--(LEFT(closed!$A$3:$A$20003,3)
="FPC"))

Jerry
Click to expand...
 
You're welcome. I can't get autocorrect to give me what I intended
instead of what I typed in those situations either ;-)

Jerry
 
Back
Top