dear friends below formula work fine for me.but i need to get that formula answer with all data.
ex-
80+80=160
but this formulas giving only last answer =160.i need see that 80+80 also.pls anybody can make macro for this.thanks.
B5 cell
=SUM(IF('Daily Production'!$D$2:$D$350="40/2",(IF('Daily Production'!$E$2:$E$350="SSP",'Daily Production'!$G$2:$G$350))))
C5 cell
=SUM(IF('Daily Production'!$D$2:$D$350="20/2",(IF('Daily Production'!$E$2:$E$350="SSP",'Daily Production'!$G$2:$G$350))))
D5 cell
=SUM(IF('Daily Production'!$D$2:$D$350="45/2",(IF('Daily Production'!$E$2:$E$350="PP",'Daily Production'!$G$2:$G$350))))
E5 cell
=SUM(IF('Daily Production'!$D$2:$D$350="16/2",(IF('Daily Production'!$E$2:$E$350="CP",'Daily Production'!$G$2:$G$350))))
Bookmarks