- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel
- 2004 May
- Using wildcards w/ sumproduct

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

- Using wildcards w/ sumproduct posted by Frank Kabel on Wed, 5 May 2004