Trying to figure out indirect with >symbol...
Hello All - new user here....
I am struggling to get the syntax correct for an INDIRECT formula referring to a combination of ">" symbol and a cell reference. An example is as follows:
=SUMIFS(A2:A10,B2:B10,INDIRECT(>C2))
Cannot get the sequencing of ", ' and & right....anyone out there who can easily let me know how its done?
With thanks
What is in C2?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
An integer, say 100
Then all you should need is this:
=SUMIFS(A2:A10,B2:B10,">C2")
Typo:=SUMIFS(A2:A10,B2:B10,">C2")
=SUMIFS(A2:A10, B2:B10, ">" & C2)
Entia non sunt multiplicanda sine necessitate
Yes, indeed - sorry - my mistake!Originally Posted by shg
Boom! problem solved....many thanks!
Took me days trying to get the indirect to work...much simpler solution
INDIRECT() is used when you need to reference/use text in a formula, in a situation where text would normally not be accepted
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You don't need INDIRECT unless you are referencing something indirectly. Here you are making a direct reference to a number in a cell.
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks