Summing based off different columns

A

Ag

I am trying to sum numbers in a column based off of another column. I only
want to sum the numbers in a column if the other column meets the criteria.
An example: Column B either has a yes or no. Column C has various numbers.
I am trying to sum the various numbers in Column C only if Column B has a
"yes." Any help would be greatly appreciated!
 
G

Glenn

Ag said:
I am trying to sum numbers in a column based off of another column. I only
want to sum the numbers in a column if the other column meets the criteria.
An example: Column B either has a yes or no. Column C has various numbers.
I am trying to sum the various numbers in Column C only if Column B has a
"yes." Any help would be greatly appreciated!
Click to expand...

=SUMIF(B:B,"yes",C:C)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
Sum Values from different column 1
Really need some help with a multi conditional SumProduct 1
SUMIFS, one criteria range, multiple criteria 3
SUM - IF - AND 7
Expansion of COUNT if Question 1
How to add values in one column based on values in another column 6
Conditional Formula with Words and different columns 5

Top