I've tried both SUMIFS and SUMPRODUCT to take the value in column B on sheet 3 if the "Section" in column A here appears in the section column A:A and the date in row B here is in row 1 on sheet 1 but I keep getting a #VALUE error...
I think it's perhaps because I am mixing requests from both Rows and Columns???
Any ideas please???
As always, heartfelt thanks...