I am using this formula to pick data and do a count, however when I use the
letter N it comes back with an error. I can substitute N with A and get the
proper result I am looking for, however I would like to use N for Navy.....
Any help would be great.
Thanks in advance JP

=SUMPRODUCT(--(TEXT(AOB!G2:G1024,"yyyymm")="200510"),--(TEXT(AOB!D2:D1024,"N")="N"))

What sort of format is N.

How about

=SUMPRODUCT(--(TEXT(AOB!G2:G1024,"yyyymm")="200510"),--(AOB!D2:D1024="N"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"FCC (SW) JP USN" wrote in message
...
I am using this formula to pick data and do a count, however when I use
the
letter N it comes back with an error. I can substitute N with A and get
the
proper result I am looking for, however I would like to use N for
Navy.....
Any help would be great.
Thanks in advance JP


=SUMPRODUCT(--(TEXT(AOB!G2:G1024,"yyyymm")="200510"),--(TEXT(AOB!D2:D1024,"N
")="N"))

Bob worked great!!!! no errors. The N is just text we use N for NAVET and O
for OSVET. The cells are formated general in that column.

Thanks for your time

John


"Bob Phillips" wrote:

What sort of format is N.

How about

=SUMPRODUCT(--(TEXT(AOB!G2:G1024,"yyyymm")="200510"),--(AOB!D2:D1024="N"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"FCC (SW) JP USN" wrote in message
...
I am using this formula to pick data and do a count, however when I use
the
letter N it comes back with an error. I can substitute N with A and get
the
proper result I am looking for, however I would like to use N for
Navy.....
Any help would be great.
Thanks in advance JP


=SUMPRODUCT(--(TEXT(AOB!G2:G1024,"yyyymm")="200510"),--(TEXT(AOB!D2:D1024,"N
")="N"))

So it is not a format at all, you just misunderstood the use of the TEXT
function?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"FCC (SW) JP USN" wrote in message
...
Bob worked great!!!! no errors. The N is just text we use N for NAVET and
O
for OSVET. The cells are formated general in that column.

Thanks for your time

John


"Bob Phillips" wrote:

What sort of format is N.

How about


=SUMPRODUCT(--(TEXT(AOB!G2:G1024,"yyyymm")="200510"),--(AOB!D2:D1024="N"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"FCC (SW) JP USN" wrote in
message
...
I am using this formula to pick data and do a count, however when I
use
the
letter N it comes back with an error. I can substitute N with A and
get
the
proper result I am looking for, however I would like to use N for
Navy.....
Any help would be great.
Thanks in advance JP



=SUMPRODUCT(--(TEXT(AOB!G2:G1024,"yyyymm")="200510"),--(TEXT(AOB!D2:D1024,"N
")="N"))