Forum Discussion

KAM_Mumin's avatar
KAM_Mumin
Copper Contributor
Sep 11, 2022
Solved

MS Excel IF/SUMPRODUCTS Formula

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

Resources