Counting Formulas -- Re-explained
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
|