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