I have the following data set:
Columns A, C, E, G, I, K = Month Year (Text)
Columns B, D, F, H, J, L = # of Hours
On a separate worksheet, I need to return the sum of the hours if a given month appears in any of the month columns . . . I've tried a few SUMIF and SUMPRODUCT combos, but it's not working?