Display a variety of cells in one cell based on multiple variables

scotchman

New Member
Joined
Nov 10, 2024
Messages
8
Office Version
  1. 365
Platform
  1. Windows
Not sure how to put this but I'll explain what I'm doing. I've created a yearly expenses tracker but in order to have the average of all the months that have gone by I have to edit the variable manually (ex for 3 months gone by =A/3)

I'd like to create a cell for each month gone by and display it in my averages column based on how many months have gone by. So if the March column has an entry in it it displays the average for 3 months. Then once the April column is full it displays the average for 4 months.

I can easily create a bunch of hidden columns but I'm not sure how to pull them to a specific column based on the variables I mentioned. Not even sure if this is possible but I'd love to know how to do it if it is.

Thanks for your help.
 

Attachments

  • excel.jpg
    excel.jpg
    90.4 KB · Views: 2
Ahh that average function should work I totally missed that reply I'll try that when I get home.
 
Upvote 0

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,224,455
Messages
6,178,768
Members
452,875
Latest member
Disastrouscoder

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top