I have a 'Master' spreadsheet with a specific reference (Master!H12) and want to return a value from different a specific column in multiple spreadsheets (i.e 'F10'B:B,'M40'!B:B), and calculating to sum where the specific reference is duplicated.
So far I've got the following formula but it calculates only a single instance from a single spreadsheet.
=if(ERROR(INDEX(('F10'!F:F),MATCH(Master!H12,'F10'!B:B,0)),"")
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I though I had this cracked, with significant help of course.
The formula works great for numeric values only but does not pick up text variables.
I need the formula to also pick up text variables ie "Omit", "Excl", "Incl", "Nil" as the result
So that if a cell has "Omit" in instead of a numerical value that will be shown.
=IF(F4<>"",SUMPRODUCT(SUMIF(INDIRECT("'"&Trades!$A$3:$A$25&"'!A3:A500"),B4,INDIRECT("'"&Trades!$A$3:$A$25&"'!E3:E500"))),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks