Hi,

Highlight C3:E2000 and convert it to a list (Ctrl+L). This will male the
ranges "auto expanding". Whenever you add data in the rows below, the range
would automatically keep expanding in the formula. Please ensure that you
do not leave blank rows, blank columns and blank cells anywhere in the
range.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"roy.okinawa" wrote in message
...
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.