Array to ignore blank cells

[Phelony]

Hi Guys

I know there are hundreds of posts with array problems, but having spent the morning sifting through these I'm still stuck.

I've got the following formula:

{=SUM(('Raw Cash'!B2:B16=B2)*('Raw Cash'!K2:K16='Output Cash'!B1)*'Raw Cash'!I2:I16)}

Where Raw Cash B is a month identifier (text) and Raw Cash K is a Deptartment identifier (text). Column I is an invoice amount as is returned as a General unformatted number.

The problem is, that the table this is searching will ultimately contain thousands of rows, although not more than 5000. How can I get the array to search from 2:5000 without it immediately collapsing and without me having to update the formula on a weekly basis!


I'm not using a pivot as I need to keep the workbook to an absolute minimum size. Furthermore, I'm stuck in 2003...

Any help would be appreciated as I'm going crazy trying to find a simple answer to this.

Thank you for your time

Phelony

 

[Comfy]

I'm sorry if I misunderstood the question:

Would this work:

=SUMPRODUCT(--('Raw Cash'!B2:B5000=B2),--('Raw Cash'!K2:K5000=B1),'Raw Cash'!I2:I5000)