Forum Discussion
Solved
How to sum up with conditions (complicated)
Hi there, I have a quit complicated question about programming with Exel. I tried to Google it and some formulas myself but it wasn’t working - maybe somebody has a solution for me. ...
=IF(B1="",SUMPRODUCT(($A$1:$A$24=A1)*$B$1:$B$24),"")Maybe with this formula for the database in the attached example.
=IF(B1="",SUMPRODUCT(($A$1:$A$24=A1)*$B$1:$B$24),"")Maybe with this formula for the database in the attached example.
Thank you so much! I was able to use this formula!