Summing based off different columns

  • Thread starter Thread starter Ag
  • Start date Start date
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!
 
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)
 
Back
Top