Perhaps "unique" is the wrong word. Maybe "only count it once" would be more accurate. I only want to sum 1 value from each of the different Org values... so if there are three unique values, there should be three numbers being summed (assuming "factorX" exists for each of them).
I am looking for a single formula, however, the formula will be replicated for each "factor" so there may end up being 6 or so...
Does that help explain it?
Bookmarks