Help to edit a formula
Hi,
I have this formula from a former co-worker and I need to add something to
it. I'm not very good at Excel formulas and need help.
The formula is: SUM(IF((AB15:AB111="T")*(ISBLANK(Y15:Y111)<TRUE), 1,0))
In Column AB we have 3 different values: A, T, and R. There is a formula
for A already in another cell. The problem I have is, I need both T and R
added up for the tally. I need to know how to modify this formula to count
both T and R.
Thank you
|