Hi,
I'm working with a program that does not support the sumproduct function. Would anyone have any idea how I can arrive to the same result the sumproduct below produces but using a different formula, for example, index.
=SUMPRODUCT(((F14:F97)=$A$45)*(H14:H97=A26),E14:E97)
I've included a sample file, sheet 2.
Thanks!
Bookmarks