Try this:

=SUMIF(B1:B100,"yes",C1:C100)

HTH,
Paul

--

"Ag" wrote in message
...
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!