Forum

Fluff
@fluff
Eminent Member
Joined: Jul 31, 2020
Last seen: Apr 8, 2025
Topics: 0 / Replies: 36
Reply
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
Reply
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
Reply
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
Reply
RE: Excel advanced filter Wildcards acting weird

To filter for something that ends with use it like ="=* - xyproductname"

4 years ago
Reply
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