Column A Column B Column C Column D Column E
Cow Cow Cat Cat 100
I need a excel formula to sum the column E
1 Firstly i need to match "cat" on column C via any formula between Column A and B
2 Based on above result "Cat", i need to match the column D and to sum the column E
Solved by F. H. in 21 mins