Forum Discussion
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 Co...
=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.
=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.
Thanks a lot brother it works,,,