Thread: IF (table)
View Single Post
  #8   Report Post  
Aladin Akyurek
 
Posts: n/a
Default IF (table)

If you are determined to dismiss SumIf in favor of SumProduct, the
answer certainly yes.

Bob Phillips wrote:
Does this not work

=SUMPRODUCT(--(ISNUMBER(FIND("4k",10:10))),13:13)

or even

=SUMPRODUCT(--(ISNUMBER(FIND("4k",E10:L10))),E13:L13)