Forum Discussion
Solved
Excel formula required
Hi, I am looking for a formula that would do a sum of the individual items on the workbook. They are not well arranged but the workbook is in use that way. I have provided a sample file with the ...
Try the following:
=SUM(MMULT(--($B$3:$F$12=$I3),TRANSPOSE($B$2:$F$2)))
sorry I can't help because I can't make sense of what you want/need. Last time I came up with a scenario where ignoring the AI and # of occurences in the same group I could make the table fit your expected results. In this new file I can't figure out how to make it work so I can't create a formula. You will need to explain how to add the items in the table to get the 'expected results'
