Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to edit formula without changing formula of each cell | Excel Worksheet Functions | |||
Formula edit | Excel Discussion (Misc queries) | |||
fx instead of "=" on formula edit bar | Excel Discussion (Misc queries) | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) | |||
= (edit formula) | Excel Discussion (Misc queries) |