Array formula data limits

[Eelman]

Hi,
I've built an array formula that references an Excel Table. Over time, this table will grow in size (ie more records) and my array formula will need to calculate more records.

My question is, will this eventually hit a limit where the array formulas stop taking in records past a certain point or throw an error.

The formula looks something like this:

{ = SUMPRODUCT( --(Table1 Condition1) * (Table1 Condition2) * (Table1 Condition3) * (Table1 Condition4) * (Table1 Condition5)) }

where,
Table1 Condition1 can be = {TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE} ... and so on

Currently, Table 1 has 30 records hence 30 x TRUE's above.

I'm by no means that good at building array formulas but I've gotten this to work and need it to continue working. That's not to say I'm not open to changing how I've structured my formula to ensure a better design - or if there's a better way to do this eg using Power Query Editor?

Thanks

[bebo021999]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.