In a form.
I want to add data from one sheet and popluate another sheet, the issue i am having is the form sheet receives new requests each day. Where and how do i change the formula below to capture all new data in the sheet. I though i would use the $ or @row, this only issue is i have a summary line at the top of my form
=SUMIF({Booking Form (Accommodation) Range 1}, ="Proj:2", {Booking Form (Accommodation) Range 1})