software

I don't know if that's the correct term for what I'm looking for, but I'm
looking for a way to to the following on a 3000 row report:

I would like column N to show values from column A that are N/A for each of
the PC Location Codes found in Column F -- like all N/A's for code C, all
N/A's for code H, all N/A's for code O, all N/A's for code S, etc. (some
codes not shown).

I would like column O to show counts for column H values that are gt; 5000,
but lt;=50000.

And finally, I'd like column P to show the count for each of the codes where
column H values are gt; 50000.Code:
A B C D E F G
H
635449 1/6/2005 2005-0018 Hot Shop C 6500
N/A 1/14/2005 2005-0002 Tool Room H 500
Can these things be accomplished?

Thank you.


quot;MABquot; gt; wrote in message
...
gt;I don't know if that's the correct term for what I'm looking for, but I'm
gt; looking for a way to to the following on a 3000 row report:
gt;
gt; I would like column N to show values from column A that are N/A for each
gt; of
gt; the PC Location Codes found in Column F -- like all N/A's for code C, all
gt; N/A's for code H, all N/A's for code O, all N/A's for code S, etc. (some
gt; codes not shown).
gt;
I'm not sure what you are asking here.

gt; I would like column O to show counts for column H values that are gt; 5000,
gt; but lt;=50000.

=if(and(H2gt;5000,H2lt;=5000),H2,NA())

gt;
gt; And finally, I'd like column P to show the count for each of the codes
gt; where
gt; column H values are gt; 50000.

Not sure what you are asking here. Do you want the count in column H that's
gt; 50000? If so, try
=COUNTIF(H:H,quot;gt;50000quot;)
gt;
gt;
Code:
gt; A B C D E F G
gt; H
gt; 635449 1/6/2005 2005-0018 Hot Shop C 6500
gt; N/A 1/14/2005 2005-0002 Tool Room H 500
gt;
gt;
gt; Can these things be accomplished?
gt;
gt; Thank you.