Quote Originally Posted by mcinnes01
with the concatenate, how does this work exactly
The concatenation simply creates a single "field" containing all values of interest.
Here we combine "Ee" with "Sick Type" giving us "Ee@SickType" value on each row in our data set.

The concatenation key means that in effect the "multi criteria field" calculation can be dispensed with as we can use the single concatenation field with SUMIF or COUNTIF etc... (and use wildcards as necessary)

These things are always best illustrated by examples - below is a demo. of this approach c/o Mike Girvin

http://www.youtube.com/watch?v=ry3vSqN1TQ0