Hi,
Am trying to apply a couple of validations to my worksheet.
Firstly, I want to make sure that in a specific range of cells(say A1:F1), the sum of the cell values does not exceed 100. I used the data validation tab and specified a custom validation with the formula (=SUM(A1:F1)<=100)...