Totals formula.xlsx
Hi all,
I have attached a work sheet on what I am trying to do if possible. Any help would be appricated.
I basicly use a template to collect data. The data is then totaled at the bottom (same template). What I am looking for is a formula that will see the new template and add that data in as well, instead of me having to redo the forumla to add the data in the new template everytime I add one.
In E31
=SUMIF($D$1:$D$30,$D31,$E$1:$E$30)
Copy down and across
Life's a spreadsheet, Excel!
Say thanks, Click *
See my attachment. The solution was to move your "Totals" box to the right and use SUMIF()'s
Mechjo16 Solution.xlsx
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
ACE_XL
This will work I just had to remove the $ in front of "E" so the column will go to the next.
=SUMIF($D$1:$D$30,$D31,E$1:E$30)
One thing though what if there were numbers greater and less than 0 I only wanted it to sum on numbers >0
Aha.. use
=SUMIFS(E$1:E$30,$D$1:$D$30,$D31,E$1:E$30,">0")
Thank you! That is the ticket I am looking for.
Originally Posted by Ace_XL
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks