Thread: Sumproduct with wildcards
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Saintsman Saintsman is offline
external usenet poster
  
Posts: 81
Default Sumproduct with wildcards
This formula works
=SUMPRODUCT(--(client=A$19),--(contractors=$A4),clientvalue)

How do I add wildcard *A$19* & *$A4*to the equation?
NB "*" & A$19 doesn't do it on it's own

Saintsman
Reply With QuoteReply With Quote