Results 1 to 2 of 2

Thread: Sumproduct formula not accurate

  1. #1

    Sumproduct formula not accurate



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Acolyte Canapone's Avatar
    Join Date
    Oct 2011
    Location
    Italy
    Posts
    97
    Articles
    0
    Excel Version
    Excel 2010
    Hi,

    a first attempt:

    =SUMPRODUCT(--('ONE'!$BZ$5:$BZ$1350<>""),--('ONE'!$CF$5:$CF$1350='Staffing '!$D$9),--(trim('ONE'!$CK$5:$CK$1350 ) =B40),--('ONE'!$F$5:$F$1350=U39))

    I hope it helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •