View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
steph
 
Posts: n/a
Default Simple SUMIF, I think...

I have 2 columns of data. In col B I have a % value; in col C I have various
project names. I need a formula that will show me the total of col B for
each project name in col C. There is no data after col C so I could use
those cols for the results.

col B col C
20% proj A
80% proj A
10% proj B
30% proj B
70% proj B
100% proj C

So my results should be 100% proj A; 110% proj B; 100% proj C. Obviously
the 110% row will require more research on my part...

--
Thanks so much!