SOLVED

MS Excel IF/SUMPRODUCTS Formula

Contributor

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,,,

kammumin_0-1662902567592.png

Annotation 2022-09-11 192506.jpg

2 Replies
best response confirmed by Hans Vogelaar (MVP)
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.

data sheet.JPG

sumproduct.JPG 

Thanks a lot brother it works,,,