Count No Of sessions(report)

[Abdulrahman7]

I have 2 sheets, one sheet having the list of training courses and the other sheet has the report of the list,


I'm facing a problem in counting number of Session I could count it but I have to specify the number of rows every time so once I add data in the list if I choose 1000(more than written rows) it will show an error, I go to my formula and edit it again.

I want it work automatically

I have attached the file wish you can help me

Thank you in advance

 

[Abdulrahman7]

Forgot to say, I highlighted the cells with Yellow color where i have to write my formula in FINAL LIST SHEET

 

[PCosta87]

Hi,

Instead of using simple ranges, try using a Table in the "Training List" sheet and then use the field names in the formulas.

See attached.

Hope this helps.

 

[Abdulrahman7]

Good morning PCosta your idea is working as I wish, instead of changing the formula in a cell, will resize the table that's awesome but, I have doubt if we do this, is it possible to make absolute reference? bcoz when I drag to right the column name changes.


Thank you for helping

 

[PCosta87]

Good morning PCosta your idea is working as I wish, instead of changing the formula in a cell, will resize the table that's awesome but, I have doubt if we do this, is it possible to make absolute reference? bcoz when I drag to right the column name changes.


Thank you for helping

Hi,

Indeed, dragging to the right will cause the fields to also shift... one way to bypass this is to copy/paste instead of dragging:


Hope this helps

 

[Abdulrahman7]

Hello PCosta,

Thanks a lot for clarification it's working 100%

 

[PCosta87]

Hello PCosta,

Thanks a lot for clarification it's working 100%

Don't mention it