Here's a thought, if the data is already sorted then use
=IF(B2=B3,"",SUMPRODUCT(--($B$2:$B2=B2),$D$2:$D2))
The headers are in row 1, the starting point is in row 2 and the range end
(initially $b2) will grow as you drag it down the rows. Now it only looks at
the rows above the formula instead of the whole column.
Should have thought of it in the first place :-(
Giz
"JackSchilder" wrote:
Thanks a lot for your reply.
Ill give it a try :)
To bad excel doesnt auto calculate the amount of rows!
Im using Jetreports to get the data out of a database, nice program but
a bit hard to handle at start when you dont much of excel ;)
--
JackSchilder
------------------------------------------------------------------------
JackSchilder's Profile: http://www.excelforum.com/member.php...o&userid=31577
View this thread: http://www.excelforum.com/showthread...hreadid=512705