R
roy.okinawa
Using the below formula as example, is there another formula I can use where
I do not need to put a ending cell to sumproduct. I know I could just put a
larger number in, but this formula is getting info from another worksheet
that has data entered everyday so it keeps growing. As you can see I have it
ending at 2000 but would like it keep formulating without always needing to
put the ending cell.
=SUMPRODUCT(--(TEXT(Overall!E3:E2000,"mmm/yyyy")=TEXT(C2,"mmm/yyyy")),--(ISNUMBER(SEARCH(A11,Overall!C3:C2000))))
Thanks.
I do not need to put a ending cell to sumproduct. I know I could just put a
larger number in, but this formula is getting info from another worksheet
that has data entered everyday so it keeps growing. As you can see I have it
ending at 2000 but would like it keep formulating without always needing to
put the ending cell.
=SUMPRODUCT(--(TEXT(Overall!E3:E2000,"mmm/yyyy")=TEXT(C2,"mmm/yyyy")),--(ISNUMBER(SEARCH(A11,Overall!C3:C2000))))
Thanks.