Paddy1979
Well-known Member
- Joined
- Sep 23, 2005
- Messages
- 608
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
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