Hi all,
I have an issue with a table. I want to sum cells of a certain column if the row contains a certain number. I uploaded a worksheet with the issue.
In the worksheet I want to sum the cells of the columns “Monday, Tuesday, etc.” per class the group belongs to. To clarify it, I added colors to the cells I want to sum and the place where I want the total of that sum. So for cell B13, I want to add all the amounts on “Monday” which are in a row where the H-column contains a 1. For cell B14, I want to add the amounts of column B where the H-column contains a 2, and so on.
I found a way to do it, but it’s such a long formula that it isn’t practical for a large table. What works for cell B13 is: =IF(H4=1|B4)+IF(H5=1|B5)+(H6=1|B6)+(H7=1|B7)+(H8=1|B8)+(H9=1|B9)+(H10=1|B10)+(H11=1|B11)
There must be an easier way and I hope you can help me find it. Thanks in advance.
Sorry for my bad English, I tried to be as clear as I could.
Bookmarks