Hi

The formula sums all amounts with given code and subcode in range from 1st
datarow to current row (the one with formula in it) in table.

The right use of absolute (preceeded with $) and relative (not preceeded
with $) references guarantees, that the referred range will be adjusted
automatically when the formula is copied.

A double unary conversion (--LogicalExpression) returns TRUE/FALSE check
results to their numeric equivalents (1/0). You can have the formula in form
=SUMPRODUCT(($A$2:$2=$A2)*($B$2:$B2=$B2)*($C$2:$C2 ))
too, but the unary conversion will suppesedly work somewhat faster - it will
count when you have a lot of such formulas on sheet.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"shankarexcel"
wrote in message
news:shankarexcel.21xkzy_1137756603.5155@excelforu m-nospam.com...

Exellent Arvi,

It's working great. Could you please explain that formula
=SUMPRODUCT(--($A$2:$2=$A2),--($B$2:$B2=$B2),$C$2:$C2)
in detail, it will be educative for me? I am new to excel.

Thanks
Shankar


--
shankarexcel
------------------------------------------------------------------------
shankarexcel's Profile:
http://www.excelforum.com/member.php...o&userid=30661
View this thread: http://www.excelforum.com/showthread...hreadid=503268