Using wildcards w/ sumproduct

Giganews Newsgroups
Subject: Using wildcards w/ sumproduct
Posted by:  Julz (jhb…
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.


Any assistance is greatly appreciated.