OK - I know this should be simple - but as an Enthusiast rather than a power user its doing my head in!
I have a table and I want to Sum rows based on column headings. Column headings may be duplicated across the sheet. I have attached a simple example of the type of table I am working on (simplified) - any help would be appreciated!
Thanks in advance!!
SimpleQuestion.xlsx
Under Data ribbon, there is a Consolidate function you can probably look into it. I put an example in the attached workbook.
Re: Noob Totaling rows based on Column heading
Perfect - so simple I did not see it!
Thanks!
Now - if I can just work out how to mark this post as solved
OK - is it possible to do the same thing with a formula? I want to be able to distribute this table for people to enter their data into and see the effect?
Thanks
You might need to extract all the column headers first. In J5, enter =SUM(IF(TRANSPOSE($C$4:$H$4)=J$3,TRANSPOSE($C5:$H5),0)) with Ctrl + Shift + Enter keys enter together.
PS: Caution on the $ sigh for the cell reference.
This uses a formula:
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks for all your help - a very happy (and relieved) person here! Saved me a few hours work!
You're welcome.
Thanks for giving feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks