PDA

View Full Version : Solved: SUMPRODUCT HELP



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 !

sassora
07-03-2012, 02:04 AM
Doesn't the following work?

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

*Removed array comment - XLD is right

Bob Phillips
07-03-2012, 02:07 AM
Doesn't the following work?

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

~Activate the cell and press ctrl- shift -enter

No need to array-enter SUMPRODUCT.

ads_3131
07-03-2012, 05:47 AM
Hey!

Spot on thanks!