Thread: sumproduct
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lacey Lacey is offline
external usenet poster
 
Posts: 26
Default sumproduct

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