Forum Discussion
Formula help needed
I need help on a formula to sum values across columns with certain criteria. I need to sum all the As, all the Bs, etc across many columns of contracts. I've simplified my example attached. I've tried various Lookup formulas, SUMIfs, and others with no success. Can anyone help?
4 Replies
Thank you for your help. That formula won't work because there is other data in between the columns. I've updated my sample, attached. Can you try again to help me, please?
The idea remains the same.
Thank you for your help. I should have noted that there are other columns of data in between the data that I want to sum and this formula is not working. I've modified my sample attached.
For example:
The formula in J2 is
=SUMIFS($B$2:$F$100, $A$2:$E$100, I2)
