Dear All,
I am trying to calculate some totals without using VBA as the spreadsheet is xlsx and I cannot change it.
I would like to perform the following calculation:
if Cell A is = "SP" or cell A = "DP" and Cell B = "X" and any Cell in Range (D:F) <> "" then sum of cells Range A:A.
As an explanation if the text value in cell A is either SP or DP and the value of cell B is equal to X and there is a value (any value) in range D:F then count the number of rows in range A:A where the criteria is met.
I have tried for a few hours but I always get Value error and I do not know why.
In anticipation of a solution
Vonryan
I am trying to calculate some totals without using VBA as the spreadsheet is xlsx and I cannot change it.
I would like to perform the following calculation:
if Cell A is = "SP" or cell A = "DP" and Cell B = "X" and any Cell in Range (D:F) <> "" then sum of cells Range A:A.
As an explanation if the text value in cell A is either SP or DP and the value of cell B is equal to X and there is a value (any value) in range D:F then count the number of rows in range A:A where the criteria is met.
I have tried for a few hours but I always get Value error and I do not know why.
In anticipation of a solution
Vonryan