Thread: formula to sum
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
HKaplan HKaplan is offline
external usenet poster
 
Posts: 80
Default formula to sum

Try this in the last row of column C:

=SUMIF(C2:C30,"x",$B$2:$B$30)

Or use a pivot table to tell you who wants what topic and for how many
total hours.