sumproduct

L

Lacey

Hi - I'm having awful problems using a wildcard in a sumproduct formulae - if
anyone could help me it would be hugely appreciated the formulae is as
follows:

COUNTA(G12:p12)*($G$2)-SUMPRODUCT((G12:p12="F*")*($G$2))

Thanks heaps for your help,
Lacey
 
R

RagDyeR

Try this:

=COUNTA(G12:p12)*($G$2)-SUMPRODUCT((LEFT(G12:p12)="F")*($G$2))
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Hi - I'm having awful problems using a wildcard in a sumproduct formulae -
if
anyone could help me it would be hugely appreciated the formulae is as
follows:

COUNTA(G12:p12)*($G$2)-SUMPRODUCT((G12:p12="F*")*($G$2))

Thanks heaps for your help,
Lacey
 
Top