hakim_tanzil
Board Regular
- Joined
- May 10, 2012
- Messages
- 56
- Office Version
- 2019
- 2016
- Platform
- Windows
Hi there,
I'm having trouble with the sumproduct formula, below are the tables:
I have one sheet for "Room" data
Room# LVL
R1 LVL1
R2 LVL1
R3 LVL1
R4 LVL2
R5 LVL2
R6 LVL2
R7 LVL3
R8 LVL3
And another sheet where I'm going to input the Room# for students who are in the LVL2 class room
Date Andy Brian Chris Doug Check
1/1 R4 R6 R4 R5 [I need a sumproduct formula to check on all the Room# that I input are all on LVL2]
2/1 R5 R2 R6 R4 [if the input is wrong, then it will show error]
I'd appreciate much if someone could help me on this. Thank you
I'm having trouble with the sumproduct formula, below are the tables:
I have one sheet for "Room" data
Room# LVL
R1 LVL1
R2 LVL1
R3 LVL1
R4 LVL2
R5 LVL2
R6 LVL2
R7 LVL3
R8 LVL3
And another sheet where I'm going to input the Room# for students who are in the LVL2 class room
Date Andy Brian Chris Doug Check
1/1 R4 R6 R4 R5 [I need a sumproduct formula to check on all the Room# that I input are all on LVL2]
2/1 R5 R2 R6 R4 [if the input is wrong, then it will show error]
I'd appreciate much if someone could help me on this. Thank you