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 (P4:P8): 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

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" wrote:

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 (P4:P8): 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

:-(

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

"Duke Carey" wrote:

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" wrote:

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 (P4:P8): 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