Broken array formula I have updated a spreadsheet I use an array formula, I adde

Question

Broken array formula

I have updated a spreadsheet I use an array formula, I added extra columnsto my sheet and the formula stopped working. Now the data range is still in place and on the updated sheet the formula just does not want to work. I have uploaded the files to my onedrive (please use link below) original is V0 and the tab's SCAR Outstanding the tab WCAR Outstanding have the original array formula. On V1 there is the updated and broken formula on tab SCAR & WCAR Outstanding.

Many thanks !!!

Explanation / Answer

Hi,

A couple of things.

1. The array formula isn't broken, it's the data that are a mess returning #N/A for that gargantuan formula in AP of the worksheet warranty cars. I enclosed it in IFERROR to get rid of the errors.

2. Column O changed as above.

3. The array formula is over the top, a simple countifs will do it. This would do the same as H3

=COUNTIFS('Warranty CAR''s'!$AR$2:$AR$800,A500,'Warranty CAR''s'!$AP$2:$AP$800,E3)

Lots of these formula now return zero because the criteria isn't satisfied.

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.