Summing based off different columns
Try
=SUMIF(B1:B30,"Yes",C1:C30)
Mike
"Ag" wrote:
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!
|