xl_psychic
Active Member
- Joined
- Jan 4, 2004
- Messages
- 359
Hi,
Im using the following formula to give me the total for all the cells matching the three criterias. However it doesn't seem to work? What am i doing wrong over here.
Here's the formula :
(SUMPRODUCT(--([TL1.xls]TL1!$H$11:$H$27="QMA - India"),--([TL1.xls]TL1!$J$11:$J$27=1),--([TL1.xls]TL1!$P$11:$P$27="Witness"),--([TL1.xls]TL1!$I$11:$I$27))
Where Column H contains Evaluator
Column J contains Week
Column P contains Type of Monitoring
Column I is the Score.
Im using the following formula to give me the total for all the cells matching the three criterias. However it doesn't seem to work? What am i doing wrong over here.
Here's the formula :
(SUMPRODUCT(--([TL1.xls]TL1!$H$11:$H$27="QMA - India"),--([TL1.xls]TL1!$J$11:$J$27=1),--([TL1.xls]TL1!$P$11:$P$27="Witness"),--([TL1.xls]TL1!$I$11:$I$27))
Where Column H contains Evaluator
Column J contains Week
Column P contains Type of Monitoring
Column I is the Score.