How do I calculate sum based on 3 conditions?
I've got 3 columns where I want that info to be "true" and if it is, then
calculate the numbers in the 4th columns for those rows that met the 3 sets
of criteria.
So, if 1) client, 2) status, and 3) type meet my criteria, then I want to
sum the numbers in another column.
I'm going around in circles. Can anyone point me in the right direction?
Thanks much!!
|