Hi Team,
Below is my data and I want to sum ranges as per Criteria.
Criteria is in Column E.
looking help in dictionary as I am trying to learn dictionary.
Excel formula =SUMPRODUCT(SUMIFS($B$2:$B$6,$A$2:$A$6,$E$2:$E$3)) it works.
Regards,
mg
Below is my data and I want to sum ranges as per Criteria.
Criteria is in Column E.
looking help in dictionary as I am trying to learn dictionary.
Name | Score | Criteria List | ||||
Dhoni | 10642 | Sehwag | ||||
Virat | 11498 | Dhoni | ||||
Rohit | 10857 | Total Scores Made by Sachin and Sehwag | 22424 | |||
Sachin | 12657 | |||||
Sehwag | 11782 |
Excel formula =SUMPRODUCT(SUMIFS($B$2:$B$6,$A$2:$A$6,$E$2:$E$3)) it works.
Regards,
mg