Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
Simple SUMIF formula gone wrong! | Excel Worksheet Functions | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
SUMIF - really simple, but beats me - help! | Excel Discussion (Misc queries) | |||
this may be simple, sumif question | Excel Worksheet Functions |