Forum

Notifications
Clear all

Finding average against each row for 7 days by creating a start date and end date

2 Posts
2 Users
0 Reactions
68 Views
(@s_shreyas)
Posts: 1
New Member
Topic starter
 

Hi,

 

This is Shreyas,I am doing a project where I am trying to create a start date and end date in separate columns where when we can choose any date as soon as the start and end date is chose the average values should be shown for a particular sector in a row so basically calculating average for a of a column for a row so that the result should show up when the dates are entered when in range.

EX

Start Date End Date 

       Dates             Row                  Column1 Column2

     5/21/2018        A1

     5/24/2018         A2

 

The Average of column 1 Against Row and similarly average of column against row and so on.The average calculated value  should show up automatically when the dates are entered

 

Any kind of suggestions would definitely help me Thanks!

 
Posted : 27/07/2018 12:30 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi Shreyas

It is not clear from your description what you wanted.

Can you please attach a sample file with the expected result? Highlight the expected result.

It will help us to understand better your requirements.

Sunny

 
Posted : 27/07/2018 8:40 pm
Share: