Hi there - this is an easy one I think but I can't seem to get it right!
Tab 1 contains a schedule listing items and quantities - there are multiple lines for each item.
I want to add the quantities from Tab 1 to a summary total for each item on tab 2.
I need this to be a formula so that if the quantities change on the Tab 1 schedule this is reflected in the summary on Tab 2.
I think this might be a SUMIF...but I can't get the range and criteria right...
Thanks
L
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hi
Use a pivot table.
Hi - should now be an attachment..
No attachment
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks