Sumproduct

[Paddy1979]

Hello All, please can you help

I'm trying to sum totals in column 'I' on worksheet 'data', the below formula is pulling in totals but they are incorrect, is there something wrong with my formula??

=SUMPRODUCT(--('06 Data'!$C$1:$C$3660=Summary!$B7)--('06 Data'!$E$1:$E$3660=Summary!$B$4),'06 Data'!$I$1:$I$3660)

Many Thanks
paddy

 

[NBVC]

You're missing a comma to separate the first 2 arrays.

=SUMPRODUCT(--('06 Data'!$C$1:$C$3660=Summary!$B7),--('06 Data'!$E$1:$E$3660=Summary!$B$4),'06 Data'!$I$1:$I$3660)

 

[hatman]

try: =SUMPRODUCT(--('06 Data'!$C$1:$C$3660=Summary!$B7),--('06 Data'!$E$1:$E$3660=Summary!$B$4),'06 Data'!$I$1:$I$3660)

 

[onlyadrafter]

Hello,

I think you have a missing comma before the second --

=SUMPRODUCT(--('06 Data'!$C$1:$C$3660=Summary!$B7),--('06 Data'!$E$1:$E$3660=Summary!$B$4),'06 Data'!$I$1:$I$3660)


Bugger: beaten to it again! - at least we all agree!

 

[Paddy1979]

thanks everyone

it was missing the ,