Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional sum?
A1= Apple B1 =12
A2= Orange B2 = 52 A3 = Orange B3= 51 A4=Banana B4=53 A5 =grape B5=43 A6=grape B6 = 6 A7=grape B7 = 88 In the C column I'd like to add the number from B column if A column the same. The end result will look like: C1= 12 C2 = 52+ 51 (as A2 and A3 both are orange so add B2 and B3 together) C3= "" (leave it blank as C2 already did the job) C4=53 C5 = 43+6 +88 (as A5, A6 and A7 are all grape, so add B5 to B7 together) C6 = "" C7 ="" so the outcome will look like this: A1= Apple B1 =12 C1=12 A2= Orange B2 = 52 C2=103 A3 = Orange B3= 51 C3= A4=Banana B4=53 C4=53 A5 =grape B5=43 C5=137 A6=grape B6 = 6 C6= A7=grape B7 = 88 C7= Any suggesion? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Rank (or rather, Conditional Range) | Excel Worksheet Functions | |||
Conditional Sum | Excel Discussion (Misc queries) | |||
Conditional Sum | Excel Worksheet Functions | |||
conditional sum | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |