Forum Discussion
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 small example and highlighted two cells I want to add together. I have a total of 10 different cells to add. Any and all help will be greatly appreciated.
Thanks,
Rhonda
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)
4 Replies
You got a good answer from HansVogelaar​ to your question for your data as arranged currently.
My reaction on looking at your image, however, was that it would make more sense AND be more efficient to organize your data differently. Presumably you're tracking attendance vs bookings at some event or other, so that would also imply you might want to add info on dates, and maybe more things as well.
In any event, I'd suggest that arranging the information into a single table, as shown below (and demonstrated in the attached file) would give that clarity on several levels. Note: the formula displayed adds values in column B from row 6 through row 25, in order to give you space to add more events. If you were to use this layout, you'd want to change those parameters, or make it into an official table so that the rows are adjusted automatically. My main purpose here is to simply suggest arranging your data differently.
Mathetes,
Thank you for the suggestions. I will put them to use in my workbook. This is very helpful. Thank you for attaching your example as well.
Rhonda
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
