Sum Column of data based on info in related cell

[bradjedis]

Greetings,

I have the following situation: data in col G5 thru G46. in Col H5 thru H46 is either a Yes or No.

I am needing to include the number amount in G5:G46 IF the answer is yes, then sum the total.


Thanks,
Brad

[HansV]

Does the following do what you want?

=SUMIF(H5:H46,"Yes",G5:G46)

[bradjedis]

Hans,

Absolutely! Thanks again, and take a break. Hoist one for the team!

[HansV]