Hello Morrigan,

Again, i worked. In the meantime I found an advice in the "Sumif and
countif" posting and came up with a sumproduct formula. if my column a
and b as before, and criteria in column c and row 4, I put this formula
in cell c6:

=SUMPRODUCT(($a$1:$a$3500 =$c5)*($b$5:$b$3500 = d$4))

across and down


Thanks,
Ari Bari


--
AriBari
------------------------------------------------------------------------
AriBari's Profile: http://www.excelforum.com/member.php...o&userid=25043
View this thread: http://www.excelforum.com/showthread...hreadid=388069