If formula not working fine

Hi,

In attached file If formula is not working fine in D Cloumn.
I have pulled down some data through Index formula.

so at at sheet 1 can i have correct formula

If Ist & Iind both Part is done then it should show "All part Done"
If only Ist Part done then it should show, "Iind Part Pending")
Also in in 11th row can 0 be elemenated?


also by pulling data through index if i want to show 0 as blank then how can i show thanks

Thanks in advance.

see the attached file

Try

=IF(AND(E7<>"",E7<>0),IF(AND(G7<>"",G7<>0),"All parts done","2nd part pending"),"1st part pending")

Use the following custom format to suppress the 0s

0;-0;;@

Thanks its worked but it i tried to count column E then all are coming as countable
file is attached where formula is not working

E2=sumproduct((b7:b11=time(13,0,0))*(len(e7:e11)>0))
f2=sumproduct((len(e7:e11)>0)*1)

Thanks its almost done buy Just one query...
If i add one condition (Criteria ) of of Team also

Suppose i need counting of US Team only then how it will be done

Heartly Thanks in Advance

Thanks its almost done but Just one query...
If i add one condition (Criteria ) of of Team also

Suppose i need counting of US Team only then how it will be done

Heartly Thanks in Advance