Sum of only SOME cells in a column

[VladNY]

I have columns P and Q. I want to be able to add up the cells in column Q, but only the cells that have data in the corresponding cell in column P, regardless of what the data is. I attached a pic to make it clearer.

Screenshot 2022-12-03 225519.png



P is the column to the left and Q is to the right. I only want to add the cells in column Q if they have data in their "sister" cells in column P.

[6StringJazzer]

This formula:

Please Login or Register  to view this content.

[VladNY]

Thank you!

[6StringJazzer]

Thanks for the rep!

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."