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