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)))
