Forum Discussion
Solved
I need help creating a formula
A = Adults, K=Kids
I need to come up with a formula to calculate how many Adults and Kids total together who selected Yes. Here's an example:
=SUM(G3:H100*(F3:F100="Yes"))
Adjust the ranges as needed.
1 Reply
=SUM(G3:H100*(F3:F100="Yes"))
Adjust the ranges as needed.