Forum Discussion
Solved
Adding Different Cells
Hi, I am trying to find a formula that will let me add the amount in several different cells together. The cells are from the same column but different cells in that column. I have attached a smal...
Do you want to add the numbers in cells that have "Booked" in the cell above? If so, use a formula such as
=SUMIFS(G2:G100, G1:G99, "Booked")
or if the value "Booked" is in another cell, say in K1:
=SUMIFS(G2:G100, G1:G99, K1)
Do you want to add the numbers in cells that have "Booked" in the cell above? If so, use a formula such as
=SUMIFS(G2:G100, G1:G99, "Booked")
or if the value "Booked" is in another cell, say in K1:
=SUMIFS(G2:G100, G1:G99, K1)
Thanks for your help Hans. This solved my problem. The top one worked for sure.
Rhonda