Forum Discussion
Adding Different Cells
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)
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
