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)))
Hi,
I have made a few changes to the file. The volume row is now appearing at the top while the individual items have extended downwards. Would you please assist do a summation of the volume per item ?
