thorpyuk
Well-known Member
- Joined
- Mar 14, 2006
- Messages
- 1,453
Hiya,
What i'm trying to do is this:
=SUMPRODUCT(--('AW08 Data'!$B$2:$B$100="D2056"),--('AW08 Data'!$A$2:$A$100=Analysis!$N$1),'AW08 Data'!C$2:C$100)
But I have another 9 codes as well as D2056.... can i use an 'or statement' within this function, or am i better off trying another route?
Thanks!
What i'm trying to do is this:
=SUMPRODUCT(--('AW08 Data'!$B$2:$B$100="D2056"),--('AW08 Data'!$A$2:$A$100=Analysis!$N$1),'AW08 Data'!C$2:C$100)
But I have another 9 codes as well as D2056.... can i use an 'or statement' within this function, or am i better off trying another route?
Thanks!