View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Crist Crist is offline
external usenet poster
 
Posts: 9
Default Question with a formula

Hi there, I am trying to create a formula for the data below that would add
volumes in column C that coorespond to the "Wash" and "Blend" (not
Blend50/50) in Column B seperately for the categories Concrete and Rock. Is
there a formula that could do this for me?

A B C
1 concrete Acid 1,002.00
2 concrete Wash 7,350.00
3 concrete Blend 9,996.00
4 concrete Blend50/50 96,178.00
5 rock Acid 500
6 rock Wash 7,140.00
7 rock Blend 10,351.00
8 rock Blend50/50 108,904.00

Thanks!