Formula Problem (Sumproduct)

[liquid1010]

I've been trying to use the following formula, and it always returns back a value of zero

=SUMPRODUCT((RenoRelo!$B$4:$B$9999=Overview!$D$27)*(RenoRelo!$E$4:$E$9999="1")*RenoRelo!$F$4:$F$9999)

RenoRelo (sheet) contains the info, and the Overview (sheet) summarizes it.
All this formula is for, is to sum the costs in RenoRelo!ColumnE, for the data that matches the value in OverviewD27, and contains 1 in column E. It always returns a value of zero

[Richard Schollar]

Hi

Posting a sample of the worksheet would help, but I note that you are using the 1 in quotes ie:

RenoRelo!$E$4:$E$9999="1"

This will probably return a 0 if the 1 in the E cells is actually numeric and not textual. Test by removing the quotes so that your formula becomes:

=SUMPRODUCT((RenoRelo!$B$4:$B$9999=Overview!$D$27) *(RenoRelo!$E$4:$E$9999=1)*RenoRelo!$F$4:$F$9999 )

Richard

[corinereyes]

Hi liquid1010,

Try:

Please Login or Register  to view this content.