Solved: SUMPRODUCT HELP

[ads_3131]

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 !

[sassora]

Doesn't the following work?

=SUMPRODUCT((TEXT(Sheet1!$C$7:$C$1043,"mmyyyy")="102007")*(Sheet1!$H$7:$H$1 043={"D","D1","D2","D3","D4","D5","D6"}))

*Removed array comment - XLD is right

[Bob Phillips]

Doesn't the following work?

=SUMPRODUCT((TEXT(Sheet1!$C$7:$C$1043,"mmyyyy")="102007")*(Sheet1!$H$7:$H$1 043={"D","D1","D2","D3","D4","D5","D6"}))

~Activate the cell and press ctrl- shift -enter

No need to array-enter SUMPRODUCT.

[ads_3131]

Hey!

Spot on thanks!