Confused Excel
New Member
I want to create a summary tab for an excel sheet where I return the points used every month for a client without having to manually add it.
So for example I have columns stating the date Sep 21 Oct 21 Nov 21 and the corresponding points in the cell below. I would like to be able to input a month date in the summary tab and it return the points used for that month - presumably by searching for that date column and returning the points. I tried with a vlookup but the date range would have to be 1st column which doesnt quite work for this exercise and likely something a bit more complex needed any help would be appreciated
So for example I have columns stating the date Sep 21 Oct 21 Nov 21 and the corresponding points in the cell below. I would like to be able to input a month date in the summary tab and it return the points used for that month - presumably by searching for that date column and returning the points. I tried with a vlookup but the date range would have to be 1st column which doesnt quite work for this exercise and likely something a bit more complex needed any help would be appreciated