Fluff
Eminent Member
Joined: Jul 31, 2020
Last seen: Apr 8, 2025
Last seen: Apr 8, 2025
Follow
RE: What is the right formula format for (IF) and (CountIf) - File attached
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...
4 years ago
RE: What is the right formula format for (IF) and (CountIf) - File attached
You're welcome & thanks for the feedback.
4 years ago
RE: What is the right formula format for (IF) and (CountIf) - File attached
Ok, for E2 try this instead =SUMIFS(Fees[1st program Fees],Fees[[Age from]:[Age from]],"<="&DataEntry[@[Age Today]:[Age Today]],Fees[[Age To...
4 years ago
RE: What is the right formula format for (IF) and (CountIf) - File attached
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(DataEntr...
4 years ago
RE: Excel advanced filter Wildcards acting weird
To filter for something that ends with use it like ="=* - xyproductname"
4 years ago
RE: Inconsistent SUMIFS result for same formula
In T23 you have a space before & after the word March. Remove them & the formula works.
5 years ago
Page 3 / 3
Prev