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)
|