Hi, have checked other related posts and not found anything that can help me yet.
I have a list of data with 3 columns; date, fruit and amount sold. The list is added to every day with new data.
I would like a formula to find the last 4 entries of a fruit (i.e Banana) from the most recent date and then produce the sum of the amount of bananas sold on those 4 identified days. When the data is updated, I would like the formula to also update to include the latest additions in finding the last 4 entries.
I appreciate that if I put my data into an Excel table and have the formulas search that, it will dynamically update when I add new data. My problem is finding a formula that searches the whole data set but only finds the last 4 entries.
I have attached an image of the excel layout. Im looking for a formula if F3. In the image, the answer for bananas for the last 4 entries should sum up to 16.
Any help would be greatly appreciated.
I have a list of data with 3 columns; date, fruit and amount sold. The list is added to every day with new data.
I would like a formula to find the last 4 entries of a fruit (i.e Banana) from the most recent date and then produce the sum of the amount of bananas sold on those 4 identified days. When the data is updated, I would like the formula to also update to include the latest additions in finding the last 4 entries.
I appreciate that if I put my data into an Excel table and have the formulas search that, it will dynamically update when I add new data. My problem is finding a formula that searches the whole data set but only finds the last 4 entries.
I have attached an image of the excel layout. Im looking for a formula if F3. In the image, the answer for bananas for the last 4 entries should sum up to 16.
Any help would be greatly appreciated.