In your 2nd table on the 1st row make the age from 0 & the age to 25

you can then use this in E2, copied across & down

=XLOOKUP(DataEntry[@[Age Today]:[Age Today]],Fees[[Age from]:[Age from]],Fees[1st program Fees],"",-1)

and this in O2

=COUNTIFS(DataEntry[Age Today],">="&[@[Age from]],DataEntry[Age Today],"<="&[@[Age To]])

If you don't have Xlookup, just shout

Thanks a lot for fast reply.

Please why there are extra characters? (check image)

Also the cell shows #NAME?

I've realized that I do not have xlookup in my formulas in Excel.

I am using Excel 2019, are you using office 365?

Do I need to install anything to be able to read and apply the formulas you used?

Thanks

Ok, for E2 try this instead

=SUMIFS(Fees[1st program Fees],Fees[[Age from]:[Age from]],"<="&DataEntry[@[Age Today]:[Age Today]],Fees[[Age To]:[Age To]],">="&DataEntry[@[Age Today]:[Age Today]])

Thanks a lot my friend.

It works 🙂

You're welcome & thanks for the feedback.

Please, @Fluff

If I want to know and learn how you did it what shall I do?

Is it to study a book or something a like?

Honestly I've just copied and pasted what you typed but I do not understand it.

I know no one has anytime to teach anyone else and I a want to learn and know in my own, so please advise.

What to do to know the formulas efficiently? 

What are the elements to know what character to otype?

Thanks a lot 🙂

There are plenty of good books & video tutorials about, which might help you. But as most of my knowledge has come from posting to sites like this, I cannot really recommend anything in particular.

Hi Nelson,

You can learn about Tables and their structured references here. If you'd like to get up to speed with formulas like this, please consider my Advanced Formulas course.

Mynda

Thanks a lot for all of you 🙂