How does that formula even work?
How does that formula even work?
Kieran,
I think this is a part of what I whished to acheive.
I thought you needed to have an equation in the criterion section that included an arithmetic expression.
Taking it a bit further, how would we use ">" instead of "="?
As in: =sumif(b2:b200,concatenate(">",c2),d2:d200)
Using =sumif(b2:b200,>c2,d2:d200) would not work as XL would consider"c2" as a value instead of as a reference.
The concatenate version turns the fixed condition into a relative one.
I may have overlooked something again here...
Thanks Kieran, you have simplified my work here!
Frankie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks