Forum Discussion
ERBAE200
May 11, 2022Copper Contributor
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.
I have just added a picture of the sheet to visualize the problem.
I want to fill the empty gaps in column C with the summed amounts from the
transaction from column B with the same transaction number from column A. Unfortunately these gaps are on different position. It’s a very long sheets why it’s impossible to to it manually.
Does anyone has an idea?
P. S. If it’s easier I could also go with the results from column C being in the column of B but as an negative amount. (And deleting column C)
thank you so much!
=IF(B1="",SUMPRODUCT(($A$1:$A$24=A1)*$B$1:$B$24),"")
Maybe with this formula for the database in the attached example.
- LorenzoSilver Contributor
- OliverScheurichGold Contributor
=IF(B1="",SUMPRODUCT(($A$1:$A$24=A1)*$B$1:$B$24),"")
Maybe with this formula for the database in the attached example.
- ERBAE200Copper ContributorThank you so much! I was able to use this formula!