View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default Summing based off different columns

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!


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