#1
|
|||
|
|||
need Index, Match, Max to return SUMPRODUCT?
I want will be as specific as possible
I have the red box (P6) returning most frequent value of P7:P18 using =IFNA(INDEX(P7:P18,MATCH(MAX(Q7:Q18),Q7:Q18,0)),"" ) I would like the Purple box (Q6) to return the SUM of all the red box (P6) names into the purple box using the amounts listed in the pink box. example Beasley's appears twice. once for $150 and once for $1200 I want the purple box to be $1350 and then I can use the =Q6 in the pink box. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Match return different row number | kimak | Excel | 1 | 03-01-2017 09:39 AM |
Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
How to make MATCH/INDEX formula return multiple successive responses. | danigirl121 | Excel | 7 | 06-08-2016 01:57 PM |
Not Exact Match to Return a Value | Alaska1 | Excel | 0 | 02-19-2015 06:58 PM |
Match Index with sumproduct/vlookup | angie.chang | Excel | 1 | 06-18-2012 08:47 AM |