M
micro1000 via OfficeKB.com
I am using this formula in my company, but the procedure has now changed and
therefor the values ("204";"0"; etc.) has to be changed from time to time.
Can someone show me a script so that the formula prompts for these values
when i click on the cell???
I hope my question is understable and clear! )
=SUMPRODUCT(('import part'!$A$2:INDEX('import part'!$A$1:$A$50000;TÆL('import
part'!$E$1:$E$50000))="204")*('import part'!$B$2:INDEX('import part'!$B$1:$B
$50000;TÆL('import part'!$E$1:$E$50000))="0")*('import part'!$G$2:INDEX
('import part'!$G$1:$G$50000;TÆL('import part'!$E$1:$E$50000))=8)*('import
part'!$F$2:INDEX('import part'!$F$1:$F$50000;TÆL('import part'!$E$1:$E$50000))
<=2)*('import part'!$E$2:INDEX('import part'!$E$1:$E$50000;TÆL('import part'!
$E$1:$E$50000))<27)*'import part'!$D$2:INDEX('import part'!$D$1:$D$50000;TÆL
('import part'!$E$1:$E$50000)))
therefor the values ("204";"0"; etc.) has to be changed from time to time.
Can someone show me a script so that the formula prompts for these values
when i click on the cell???
I hope my question is understable and clear! )
=SUMPRODUCT(('import part'!$A$2:INDEX('import part'!$A$1:$A$50000;TÆL('import
part'!$E$1:$E$50000))="204")*('import part'!$B$2:INDEX('import part'!$B$1:$B
$50000;TÆL('import part'!$E$1:$E$50000))="0")*('import part'!$G$2:INDEX
('import part'!$G$1:$G$50000;TÆL('import part'!$E$1:$E$50000))=8)*('import
part'!$F$2:INDEX('import part'!$F$1:$F$50000;TÆL('import part'!$E$1:$E$50000))
<=2)*('import part'!$E$2:INDEX('import part'!$E$1:$E$50000;TÆL('import part'!
$E$1:$E$50000))<27)*'import part'!$D$2:INDEX('import part'!$D$1:$D$50000;TÆL
('import part'!$E$1:$E$50000)))