Help to edit a formula

[Guest]

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

 

[Guest]

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

ctrl+shift+enter, not just enter

 

[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

 

[Guest]

Another way...

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

 

[Guest]

correction:

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

 

[T. Valko]

Try this (normally entered, not array entered):

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

Biff

 

[Guest]

Hi Teethless mama,

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

 

[Guest]

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

 

[Guest]

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