PDA

View Full Version : Solved: Sumproduct Question



ads_3131
06-28-2012, 07:08 AM
Hello

Im having touble with the below formula....

The formula works on the same sheet which its ranges are... but how do i get it to work on my secondary sheet which is called (NCR & PROCESS PERFORMANCE) looking back at the first sheets range?

=SUMPRODUCT((TEXT($C$7:$C$1058,"mmyyyy")="042009")*($H$7:$H$1058={"F2"}))

i assumed by putting in 'NCR PROCESS PERFORMANCE'! but that doesnt work :dunno

any help would be great

Bob Phillips
06-28-2012, 07:31 AM
=SUMPRODUCT((TEXT('NCR PROCESS PERFORMANCE'!$C$7:$C$1058,"mmyyyy")="042009")
*('NCR PROCESS PERFORMANCE'!$H$7:$H$1058="F2"))