ads_3131
07-03-2012, 01:50 AM
Hello
Im struggling with my formula below refering to another sheet using EXCEL 2000? Sheet i want this formula refering to is "SHEET1"
=SUMPRODUCT((TEXT($C$7:$C$1043,"mmyyyy")="102007")*($H$7:$H$1043={"D","D1","D2","D3","D4","D5","D6"}))
is it possible ?
Any help would be great !
Im struggling with my formula below refering to another sheet using EXCEL 2000? Sheet i want this formula refering to is "SHEET1"
=SUMPRODUCT((TEXT($C$7:$C$1043,"mmyyyy")="102007")*($H$7:$H$1043={"D","D1","D2","D3","D4","D5","D6"}))
is it possible ?
Any help would be great !