I have data that exports into excel in the format shown in the tab called "Data Export." I am trying to then create a formula (in the Sheet2 tab) that pulls in YTD cumulative numbers by account, by product. The formula I've used (as shown in my sample workbook), pulls in the first row of data but doesn't sum which I think has to do with the fact that the account in Column A is merged. Is there a formula for this without having to un-merge column A?
Please try at B6
=SUMPRODUCT(--(LOOKUP(ROW('Data Export'!$A$3:$A$8),ROW('Data Export'!$A$3:$A$8)/('Data Export'!$A$3:$A$8>0))=MATCH($A6,'Data Export'!$A:$A,)),INDEX('Data Export'!$C$3:$F$8,,MATCH(LOOKUP("z",$B$4:B$4),'Data Export'!$C$1:$F$1,)+MATCH(B$5,'Data Export'!$C$2:$D$2,)-1))
Please Login or Register to view this content.
This solution worked great. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks