ARRAY formula replaced .
Normal formula in C3 then copied.
=IFERROR(SUMPRODUCT(MMULT(SUMIF(OFFSET('Parts Table'!$D$3,MATCH($B3,'Parts Table'!$B$3:$B$30,0)-1,COLUMN($D$3:$M$3)-COLUMN($D$3)),">0"),SUMIF(OFFSET('Units Sold by Model & Market'!$C$3:$C$22,21*(ROW($1:$10)-1),COLUMNS($C3:C3)-1),">0"))),"")
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Thank you for this formula. The resulting value equals the total sold, but it does not seemOriginally Posted by kvsrinivasamurthy
ARRAY formula replaced .
Normal formula in C3 then copied.
=IFERROR(SUMPRODUCT(MMULT(SUMIF(OFFSET('Parts Table'!$D$3,MATCH($B3,'Parts Table'!$B$3:$B$30,0)-1,COLUMN($D$3:$M$3)-COLUMN($D$3)),">0"),SUMIF(OFFSET('Units Sold by Model & Market'!$C$3:$C$22,21*(ROW($1:$10)-1),COLUMNS($C3:C3)-1),">0"))),"")
to not count a market if the "Increase %" in that market in the Parts Table is zero, which
means to not count the number sold for that market from the Units Sold by Model & Market.
Can you please confirm. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Gallegos 
Register To Reply
Bookmarks