Does anybody have experience converting sumif's into a tablematch? Is it possible to include a sum column in the tablematch table or would the sum need to be addressed in the formulas?
Interesting. Should work bc when you reference the TableMatch, you're just pulling back data based on the wild card entered. You may could do the sumif directly in the TableMatch or in another table and do a Lookup from the TableMatch. I'm speaking with my R11 hat on, tho. I don't have my R12 hat yet.
Thanks Jenny! I'll give that a try. For now, I just used tablematch to create a new column then did a sumif on that new column and amounts...seems to be working!
Sweet - going to have to try that out myself!
Retrieving data ...