Forum Discussion
KAM_Mumin
Sep 11, 2022Copper Contributor
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,,,
=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.
2 Replies
Sort By
- OliverScheurichGold Contributor
=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.
- KAM_MuminCopper ContributorThanks a lot brother it works,,,