Using Arrayformula when formula contains sumproduct

5 views
Skip to first unread message

Bob Blightman

unread,
Mar 24, 2026, 7:29:39 AM (9 days ago) Mar 24
to Google Sheets Community
I have a google form linked to a google sheet
I have some formulas for other columns in the sheet where the submission has been placed
When a new submission has been made, I want those formulae to be automatically generated for the new row
Most of these I have been able to do using the formula arrayformula, so this for instance, works fine
=arrayformula(if(C2:C="","",B2:B&","&TEXT(weeknum(C2:C),0)&","&text(year(C2:C),0)))

But I have a couple of other more difficult ones which use sumproduct:
=SUMPRODUCT(((($H$2:$H2=H3)*1)*($R$2:$R2="Approved")*1)*($S$2:$S2>AllocationFreeBooking)*1)

Can I wrap an arrayformula around this? I'm struggling with the syntax!
Reply all
Reply to author
Forward
0 new messages