So I have a formula that is working:
=SUMPRODUCT(--(ISNUMBER(FIND(E1,B1:B100))),N1:N100)
This Looks in column B for the text in cell E1, then sums all the matches of column N
To make it simple
Column B Column N Cell E1 = 868
86800 50.00
86812 150.00
86813 12.00
86800 20.00
87820 30.00
87823 15.75
The forumla will result in the summing of N that has column B of "868" anywhere in the CEll.
WHAT I NEED IS THIS:
to sum based on an ARRAY of criteria, not just what's in E1.
Need E1, or e2, or e3.... ?
Can anyone help?
Bookmarks