Sample AttachedSimple Sample.xlsx
What I would like to accomplish is having all the values summed up by their function by month.
EG: Function 1 (ZZ) = 14 for Jan
Function 2 (ZY) = 10
ETC...
The problem is I would like to have the ability to add more Tests and functions and have it all summed on another sheet when I add more.
I was thinking of using IF statements and VLOOKUPS but I don't have the eye to write it efficiently.
Any help would be greatly appreciated.
Do you have to keep this layout or can you use another one?
If you are able to change the structure slightly, a Pivot table will probably be your best bet.
Please click the * icon below if I have helped.
Did not even think to use Pivot tables!
Thank you!
Not sure where you are putting this sum but you could use SUMPRODUCT like so;
Formula:
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks