MS Excel IF/SUMPRODUCTS Formula

[KAM_Mumin]

Hay Everyone have a Good day!

I want to count means sums the number of amount with two criteria at first where the dates match with the data sheet then it gets the rows date with 3 types "Renting Cost, Food Bill, Other Cost" entry and then count the amount and put it to the specific column for "Renting Cost, Food Bill, Other Cost" in another sheet,,,

I tried to put some formula but failed,, plz can any one help me to solve this what formula can I put here,,, I attach a screen short below then can get some ideas how it is,,,

 

[#2 · Accepted solution]

@KAM_Mumin 

=SUMPRODUCT(($B6='Data sheet'!$A$3:$A$13)*(C$5='Data sheet'!$B$3:$B$13)*'Data sheet'!$C$3:$C$13)

Maybe with this formula.

 

[#3]

Thanks a lot brother it works,,,