Using wildcards w/ sumproduct

Giganews Newsgroups
Subject: Using wildcards w/ sumproduct
Posted by:  Julz (jhb…@austin.rr.com)
Date: Wed, 05 May 2004

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

Replies