View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tonefbr tonefbr is offline
external usenet poster
 
Posts: 5
Default SUMIF/COUNTIF problems

I would like to sum all occurences of a value in Column A, if another value
occurs in column B in the same row... but I cant figure out how to do it.
Essentially I want to calculate 'How many times does Column A = 1 when Column
B = Yes'? Any help would be most appreciated.