Help to edit a formula

H

Hell-fire

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
 
T

Teethless mama

SUM(IF((AB15:AB111={"T","R"})*(ISBLANK(Y15:Y111)<>TRUE),1,0))

ctrl+shift+enter, not just enter
 
B

Bernie Deitrick

HF,

Array enter (enter using Ctrl-Shift-Enter)

=SUM(((AB15:AB111="R")+(AB15:AB111="T"))*(Y15:Y111<>""))

If you enter it correctly, Excel will put { } around the formula.

HTH,
Bernie
MS Excel MVP
 
T

T. Valko

Try this (normally entered, not array entered):

=SUMPRODUCT((AB15:AB111={"A","R","T"})*(Y15:Y111<>""))

Biff
 
H

Hell-fire

Hi Teethless mama,

Thank you very much for responding and your suggestion. It works like a
charm.
 
H

Hell-fire

Hi Bernie,

Thank you for responding and your suggestion. Will make a note of it for
future reference as I learn how to do formulas in Excel
 
H

Hell-fire

Hi T. Valko,

Thank you for responding and your suggestion. Will make a note of it for
future reference as I learn how to do formulas in Excel
 
Top