Would sumproduct be the best formula to use for summarising a list of data? I have a worksheet with 400 rows representing practices.
Each practice currently has a row where they need to fill in columns of data. If they enter data into one column (Col D) I want a summary table showing this column along with the practice contact details in col A, B & C.
Anyone any ideas?
Bookmarks