Hi all,
I am using Sum + If functions to get results but it is lengthy formula( may
it can be shorten that I don't know how) .... it's taking much more time to
get update because it has reference from another file. I want to lessen the
time by coding in work sheet. here is the formula
=IF(D5=SUM(IF(('G:\MKT\NAS\LV Retics for Operations\[Plotting of LV Retics
for Operations_STATUS.xls]KIOSK & INDOOR SUB
LIST'!$F$2:$F$2920=B5)*('G:\MKT\NAS\LV Retics for Operations\[Plotting of LV
Retics for Operations_STATUS.xls]KIOSK & INDOOR SUB
LIST'!$O$2:$O$2920="NRAO")+('G:\MKT\NAS\LV Retics for Operations\[Plotting of
LV Retics for Operations_STATUS.xls]KIOSK & INDOOR SUB
LIST'!$F$2:$F$2920=B5)*('G:\MKT\NAS\LV Retics for Operations\[Plotting of LV
Retics for Operations_STATUS.xls]KIOSK & INDOOR SUB
LIST'!$O$2:$O$2920="VRAO")+('G:\MKT\NAS\LV Retics for Operations\[Plotting of
LV Retics for Operations_STATUS.xls]KIOSK & INDOOR SUB
LIST'!$F$2:$F$2920=B5)*('G:\MKT\NAS\LV Retics for Operations\[Plotting of LV
Retics for Operations_STATUS.xls]KIOSK & INDOOR SUB
LIST'!$O$2:$O$2920="NA"),1)),"comp","yts/pend")

if anyone want me to send files I will send two excels.

Please help me how to code in work sheet? are there any sites to learn how
to code?

thanks in advance.
dad