Hi,
I am having a little trouble in excel with a look up. I have attached a sample file of the data. I am trying to sum the amount column in the data tab where column L (data tab) matches colmun c in the sumary tab for each "Period Number" which runs horizontally in the Summary tab and vertically in the data tab.
I hope this makes sense. Many thanks.
I'm unable to upload the attachment sorry... so can't really show you in excel what I am trying to do.
Dan,
the attachment didn't make it. Please attach again.
Click GO ADVANCED
Click the paperclip icon
Browse to find your document and select it
Click on UPLOAD and wait patiently while it uploads
When the document name appears as attached, close the attachment window
Submit your new post.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks