Hi all,

I need a one simlpe function to return true if all the pairs are entered
correctly in both Column A and B and false if ANY of the pairs misses an
entry in either Column A or B. To illustrate:

(True)
A B
1 ABC 100
2 DEF 50
3 GHI 10

(False)
A B
1 ABC 100
2 DEF
3 10

Something along the line of {=SUM(A1:A3, B1:B3)}???

Thanks in advance
---
Tetsuya Oguma Singapore