Hiya guys,
I hope you are keeping well and the sun is out where you are..
I am struggling a little with this one in that I am trying to create a summary sheet that updates when input data is added.
I'm still learning many parts of excel and I'm unsure why the SUMIF function on occasion leaves duplicate data in.
I have posted a similar conundrum before and some posters have kindly responded but I found that the solutions broke down in differing scenarios.
I can live with the fact that I will need to correct the input data and am willing to just paste in corrected data when it has been validated via the data validation tab.
Once this has been done, all I am seeking is for a subsequent process to start which updates a summary sheet with the sums correctly adding via the sumif function.
I have left some instructions on the actual spreadsheet to help clarify my intended results.
Many thanks in anticipation.
Tutsyboy
https://www.dropbox.com/s/sk81w3ybveavvqh/Ledgers%20v3.xlsx
I hope you are keeping well and the sun is out where you are..
I am struggling a little with this one in that I am trying to create a summary sheet that updates when input data is added.
I'm still learning many parts of excel and I'm unsure why the SUMIF function on occasion leaves duplicate data in.
I have posted a similar conundrum before and some posters have kindly responded but I found that the solutions broke down in differing scenarios.
I can live with the fact that I will need to correct the input data and am willing to just paste in corrected data when it has been validated via the data validation tab.
Once this has been done, all I am seeking is for a subsequent process to start which updates a summary sheet with the sums correctly adding via the sumif function.
I have left some instructions on the actual spreadsheet to help clarify my intended results.
Many thanks in anticipation.
Tutsyboy
https://www.dropbox.com/s/sk81w3ybveavvqh/Ledgers%20v3.xlsx
