indexin counting

[jimblimm]

MY SETUP

a1:a10(days)
1
2
3
4
5
6
7
8
9
10

b1:b10(item)
socks
socks
turbin
socks
socks
drapes
socks
socks
socks
drapes

c1:c10 (count)
0
1
2
0
0
3
0
1
1
2

i need several formulas in d1 e1 and f1

first formula a need a count on how many days column b=socks, column c=0
answer displayed in d1

second formula i need to know the last day column b=socks, column c=0
answer displayed in e1

third formula i need the to know the last day column b=socks, column c=0
and repeated the next day column b=socks, column c=0
answer displayed in f1

answers should be d1=4

e1=7

f1=5

 

[Michael M]

Isn't this the same / similar question
http://www.mrexcel.com/forum/showthread.php?t=639427

 

[jimblimm]

is it a way of doing this without vba

 

[Michael M]

I doubt it, but it will probably get a quicker solution by
1. Staying on the original thread
2. providing ALL of the required information at the outset.

 

[xenou]

This thread is closed. Continued here (same subject):
http://www.mrexcel.com/forum/showthread.php?t=639427