Hello, I have a file with multiple worksheets and I need to summarise the number of filled cells below each specific column heading in a different spreadsheet. Is there a formula to do this?
eg Sheet 1
column headings are fruit
rows below contain locations selling the fruit
Sheet2
column headings are flowers
rows below contain locations selling the flowers
Summary sheet
contain headings from all sheets and number of locations selling each products
Banana 2
daffodil 4
Pineapple 7
Hope this makes sense!
eg Sheet 1
column headings are fruit
rows below contain locations selling the fruit
Sheet2
column headings are flowers
rows below contain locations selling the flowers
Summary sheet
contain headings from all sheets and number of locations selling each products
Banana 2
daffodil 4
Pineapple 7
Hope this makes sense!
