View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Soth Soth is offline
external usenet poster
 
Posts: 55
Default Need Help with formula writing

Hi-

I'd need a formula in colum 'C'. If the number in colum A is matched, then
sum-up the total,e.g 20 in column C; else return value in column B, e.g 5,
and 15.

A B = c
2006 10
2006 10 20
2111 5 5
2112 15 15

Regards,
Soth