LinkBack URL
About LinkBacks
michaelweaver4 
Try:
Note: the vertical range sizes have to be the same
=MAX(SUMIFS(OFFSET('All Data'!JO2:JO4996,0,ROW(INDIRECT("1:30"))-1),'All Data'!A2:A4996,"HRNP",'All Data'!X2:X4996,'FT Flex Sliced Info'!D22))
Confirm with CTRL+SHIFT+ENTER
Try:
Note: the vertical range sizes have to be the same=MAX(SUMIFS(OFFSET('All Data'!JO2:JO4996,0,ROW(INDIRECT("1:30"))-1),'All Data'!A2:A4996,"HRNP",'All Data'!X2:X4996,'FT Flex Sliced Info'!D22))
Confirm with CTRL+SHIFT+ENTER
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks