Need Help with formula writing
Try this:
Entered in C1 and copied down as needed:
=IF(A1=A2,"",SUMIF(A$1:A1,A1,B$1:B1))
--
Biff
Microsoft Excel MVP
"Soth" wrote in message
...
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
|