I have a max field that the results should be between 1 and 4. I want to sum this field in column 1 if the results = 1, sum in column 2 if the results = 2, sum in column 3 if the results = 3 and sum in column 4 if the results = 4.
column 1 column 2 column 3 column 4
3 5 2 8
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.