sumproduct

[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(G1212)*($G$2)-SUMPRODUCT((G1212="F*")*($G$2))

Thanks heaps for your help,
Lacey

 

[Pete_UK]

Try it with:

LEFT(G1212,1)="F"

Hope this helps.

Pete

 

[RagDyeR]

Try this:

=COUNTA(G1212)*($G$2)-SUMPRODUCT((LEFT(G1212)="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(G1212)*($G$2)-SUMPRODUCT((G1212="F*")*($G$2))

Thanks heaps for your help,
Lacey

 

[Lacey]

Brilliant - thanks heaps guys working beautifully!

 

[RagDyer]

We appreciate the feed-back.