View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hell-fire[_3_] Hell-fire[_3_] is offline
external usenet poster
 
Posts: 31
Default 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