Log In
Register
Home
November 1, 2020
Offline
Hi,
I tried to add the 2 formulas but can not set it correctly.
I want to add the IF formula to the DataEntry table and CountIF formula to the Fees table.
Thanks
See AnswerJuly 31, 2020
Offline
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
November 1, 2020
Offline
Thanks a lot for fast reply.
Please why there are extra characters? (check image)
Also the cell shows #NAME?
November 1, 2020
Offline
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
July 31, 2020
Offline
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]])
Answers Post
November 1, 2020
Offline
Thanks a lot my friend.
It works 🙂
July 31, 2020
Offline
You're welcome & thanks for the feedback.
November 1, 2020
Offline
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 🙂
July 31, 2020
Offline
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.
July 16, 2010
Offline
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
1 Guest(s)
