Hi
I am sorry if this question has already been resolved but I cannot find a solution that meets my needs.
I have spread sheet where the criteria is in row 5 and sum range is also a row.
The problem is the number of columns containing the criteria will be different each time report is run.
In above example there are only 2 sets of data, next time there maybe 4 sets or just 1.
I need to be able to sum the data if there are 2 records or 4 or 1.
I hope I have explained suffeciently.
Thanks for any assistance you can give.
Coop123
I am sorry if this question has already been resolved but I cannot find a solution that meets my needs.
I have spread sheet where the criteria is in row 5 and sum range is also a row.
The problem is the number of columns containing the criteria will be different each time report is run.
In above example there are only 2 sets of data, next time there maybe 4 sets or just 1.
I need to be able to sum the data if there are 2 records or 4 or 1.
I hope I have explained suffeciently.
Thanks for any assistance you can give.
Coop123