Hi
I would like to add up the values from the row that matches the subject to put on another sheet. So for example if the subject is Drama I would like to find out the row and then add up from columns B to G.
Capture.JPG
Is this possible with a formula?
Thanks
Bookmarks