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"))