Hi,
I have a sheet with three columns: "Store name", "Expected income" and "Actual income".
Each store has its own actual and expected incomes.
I want a cell to tell me how many stores in total achieved a lower than expected income.
I want to do this without adding another "difference" column.
I was thinking the formula might be along the lines of
=COUNTIF(R2C2:R11C2,"<"&R2C3:R11C3)
But this is wrong![]()
Can anyone help me please?
x
Bookmarks