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

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

ctrl+shift+enter, not just enter


"Hell-fire" wrote:

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

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


"Hell-fire" wrote in message
...
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

Another way...

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


"Hell-fire" wrote:

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

correction:

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


"Teethless mama" wrote:

Another way...

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


"Hell-fire" wrote:

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

Try this (normally entered, not array entered):

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

Biff

"Hell-fire" wrote in message
...
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

Hi Teethless mama,

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

"Teethless mama" wrote:

correction:

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


"Teethless mama" wrote:

Another way...

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


"Hell-fire" wrote:

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

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

"Bernie Deitrick" wrote:

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


"Hell-fire" wrote in message
...
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

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

"T. Valko" wrote:

Try this (normally entered, not array entered):

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

Biff

"Hell-fire" wrote in message
...
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