Counting Formulas -- Re-explained

[MAB]

I put in a question about this yesterday, but I didn't really word it too
well. Someone did offer assistance, but due to my poor explanation, the info
provided didn't work.

I'll try again...

I would like the following:

Column N (N4:N8): This should show individual totals for various PC
location codes found in column F that corresponds with an N/A in the same row
from over in column A. (PC location codes are C, S, H, F, & O -- so all N/A's
for C, all N/A's for S, etc).

Column O (O4:O8): This should show individual totals for various PC location
codes found in column F that are > 5000, but <=50000. (PC location codes are
C, S, H, F, & O -- so all instances of > 5000, but <=50000 for C, all
instances of > 5000, but <=50000 for S, etc).

Column P (P48): This should show individual totals for various PC
location codes found in column F that are > 50000. (PC location codes are C,
S, H, F, & O -- so all instances of > 50000 for C, all instances of > 50000
for S, etc).

Can this be accompplished?

Thank you.

MAB

 

[Duke Carey]

Sounds as though you mean to use "count" instead of "totals" for these, right?

To get the count of PC code C and N/As, use

=SUMPRODUCT(--(A1:A1000="C"),--(F1:F1000)="N/A")

Change the "C" to "S", etc for the other ones.

For the numeric codes, use
=SUMPRODUCT(--(A1:A1000="C"),--(F1:F1000)>5000,--(F1:F1000)<=50000)

modify these to meet your other needs

 

[MAB]

:-(

I tried it and it didn't work (I took out the --). I shouldn't say they
dind't work, but the results all come back as "0" and I know none of the
results should equal zero.

To confirm, I want to compare the codes in column F against data in colum A,
and count each N/A encountered, for each separate code. Is the code you
provided doing that?

Thanks again.

MAB