HI EVERYONE,
TO START I REALIZED THAT MY NESTED SUMPRODUCT FORMULA IS INACCURATE. I HAVE A FEW COLUMNS ON ANOTHER SHEET THAT IT PULLS DATA FROM, ONE OF THE COLUMNS WAS CREATED BY A TEXT TO COLUMN. THE SUMPRODUCT COMPLETELY IGNORES ALL THE DATA IN THE COLUMN THAT WAS THE RESULT OF THE TEXT TO COLUMN. THAT PORTION IN THE FORMULA IS BOLDED IN RED. I HAVE NO IDEA WHY THIS IS HAPPENING.
HERE'S THE FORMULA.
=SUMPRODUCT(--('ONE'!$BZ$5:$BZ$1350<>""),--('ONE'!$CF$5:$CF$1350='Staffing '!$D$9),--('ONE'!$CK$5:$CK$1350=B40),--('ONE'!$F$5:$F$1350=U39))
ANY HELP WILL GREATLY BE APPRECIATED. ALSO THIS NOT CROSS POSTED AT THE TIME THIS WAS PUBLISHED.
THANK YOU MZING81
TO START I REALIZED THAT MY NESTED SUMPRODUCT FORMULA IS INACCURATE. I HAVE A FEW COLUMNS ON ANOTHER SHEET THAT IT PULLS DATA FROM, ONE OF THE COLUMNS WAS CREATED BY A TEXT TO COLUMN. THE SUMPRODUCT COMPLETELY IGNORES ALL THE DATA IN THE COLUMN THAT WAS THE RESULT OF THE TEXT TO COLUMN. THAT PORTION IN THE FORMULA IS BOLDED IN RED. I HAVE NO IDEA WHY THIS IS HAPPENING.
HERE'S THE FORMULA.
=SUMPRODUCT(--('ONE'!$BZ$5:$BZ$1350<>""),--('ONE'!$CF$5:$CF$1350='Staffing '!$D$9),--('ONE'!$CK$5:$CK$1350=B40),--('ONE'!$F$5:$F$1350=U39))
ANY HELP WILL GREATLY BE APPRECIATED. ALSO THIS NOT CROSS POSTED AT THE TIME THIS WAS PUBLISHED.
THANK YOU MZING81