Dear Sir,

i want to know the formula how to count value of B column 20, 40, 40hc &
40flt which value in C clumn is starting from zero and grader then zero
(except minuse value)

example

a b c d
12348 20 0 almar
23456 40 2 jv
98745 40hc -2 jv
25896 40flt 10 rsl
12348 20 -1 almar
23456 40 9 cim
98745 40hc -2 rsl
25896 40flt 13 rsl
12348 20 0 rsl
23456 40 2 cim
98745 40hc -2 almar
25896 40flt 10 cim

i need the result in following shap

20 40 40HC 40FLT
ALMAR 01 00 00 00
JV 00 01 00 00
CIM 01 02 00 01
RSL 00 00 00 02

TOTAL
20 40 40hc 40flt
02 03 00 03

i need the formula like countif or sumproduct

also i need conditional formula in above result how many cntrs are coverd in
0-5 days and how many covered in 6-10 days and how many after 10 days like
below

===========<<0-5 days====== =========<<6-10days==========
========<<more then 10days=========
20 40 40HC 40FLT 20 40 40HC 40FLT 20 40 40HC 40FLT
ALMAR 01 00 00 00
JV 00 01 00 00
CIM 01 02 00 01
RSL 00 00 00 02

thanks in advance for support and help

regards
Malik