2k05gt
Board Regular
- Joined
- Sep 1, 2006
- Messages
- 157
Cell1 Cell2
25 25
FULL 20
COMPLETED 200
25 25
25 25
COMPLETED 40
I need to find the word COMPLETED in all cell1 then add up the figure in cell2
there are hundreds of rows I tried Find and Counif with find, but got lost after this.
=SUMPRODUCT(--(LEFT(B2:B2135,7)="completed"), Sum(C2:C2135=""))
25 25
FULL 20
COMPLETED 200
25 25
25 25
COMPLETED 40
I need to find the word COMPLETED in all cell1 then add up the figure in cell2
there are hundreds of rows I tried Find and Counif with find, but got lost after this.
=SUMPRODUCT(--(LEFT(B2:B2135,7)="completed"), Sum(C2:C2135=""))