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
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