software

I put in a question about this the last couple days, and I got some answers,
but due to my poor explanation, the info provided didn't work.

I'll try again... :-)

I would like to know if the following is possible:

1) 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, amp; O -- so all N/A's
for C, all N/A's for S, etc).

To confirm, I want to compare the codes in column F against data in column
A, and count each N/A encountered, for each separate code.

Per a previous suggestion, I tried using
=SUMPRODUCT((A1:A1000=quot;Cquot;),(F1:F1000)=quot;N/Aquot;), but it didn't work. I
shouldn't say they didn't work, but the results all come back as quot;0quot; and I
know none of the results should equal zero.

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

For this I tried using
=SUMPRODUCT((A1:A1000=quot;Cquot;),(F1:F1000)gt;5000,(F1:F10 00)lt;=50000), but as in the
case above I got back quot;0quot; as my results and I shouldn't have.

3) Column P (P4:P8): This should show individual totals for various PC
location codes found in column F that are gt; 50000. (PC location codes are C,
S, H, F, amp; O -- so all instances of gt; 50000 for C, all instances of gt; 50000
for S, etc).

I didn't know what to do for this one. :-p

Thanks in advance for everyone's help. I normally wouldn't take up this
much space, but I my poor explanations of what I'm hoping to use caused the
multiple posts. :-)

MAB



quot;MABquot; gt; wrote in message
...
gt; I put in a question about this the last couple days, and I got some
answers,
gt; but due to my poor explanation, the info provided didn't work.
gt;
gt; I'll try again... :-)
gt;
gt; I would like to know if the following is possible:
gt;
gt; 1) Column N (N4:N8): This should show individual totals for various PC
gt; location codes found in column F that corresponds with an N/A in the same
row
gt; from over in column A. (PC location codes are C, S, H, F, amp; O -- so all
N/A's
gt; for C, all N/A's for S, etc).
gt;
gt; To confirm, I want to compare the codes in column F against data in column
gt; A, and count each N/A encountered, for each separate code.
gt;
gt; Per a previous suggestion, I tried using
gt; =SUMPRODUCT((A1:A1000=quot;Cquot;),(F1:F1000)=quot;N/Aquot;), but it didn't work. I
gt; shouldn't say they didn't work, but the results all come back as quot;0quot; and I
gt; know none of the results should equal zero.

The formula should be

=SUMPRODUCT(--(A1:A1000=quot;Cquot;),--(F1:F1000=quot;N/Aquot;))

and this assumes a text of N/A, not a #N/A as a result of a formula.

gt; 2) Column O (O4:O8): This should show individual totals for various PC
gt; location codes found in column F that are gt; 5000, but lt;=50000. (PC
location
gt; codes are C, S, H, F, amp; O -- so all instances of gt; 5000, but lt;=50000 for
C,
gt; all instances of gt; 5000, but lt;=50000 for S, etc).
gt;
gt; For this I tried using
gt; =SUMPRODUCT((A1:A1000=quot;Cquot;),(F1:F1000)gt;5000,(F1:F10 00)lt;=50000), but as in
the
gt; case above I got back quot;0quot; as my results and I shouldn't have.

Syntax again

=SUMPRODUCT(--($A$1:$A$1000=quot;Cquot;),--($F$1:$F$1000gt;5000),--($F$1:$F$1000lt;=5000
0))gt; 3) Column P (P4:P8): This should show individual totals for various PC
gt; location codes found in column F that are gt; 50000. (PC location codes are
C,
gt; S, H, F, amp; O -- so all instances of gt; 50000 for C, all instances of gt;
50000
gt; for S, etc).

Is that not simply=SUMPRODUCT(--($A$1:$A$1000=quot;Cquot;),--($F$1:$F$1000gt;5000))
Woohoo!

They worked. Thank you very much.

Have a great day!

MAB

quot;Bob Phillipsquot; wrote:

gt;
gt;
gt; quot;MABquot; gt; wrote in message
gt; ...
gt; gt; I put in a question about this the last couple days, and I got some
gt; answers,
gt; gt; but due to my poor explanation, the info provided didn't work.
gt; gt;
gt; gt; I'll try again... :-)
gt; gt;
gt; gt; I would like to know if the following is possible:
gt; gt;
gt; gt; 1) Column N (N4:N8): This should show individual totals for various PC
gt; gt; location codes found in column F that corresponds with an N/A in the same
gt; row
gt; gt; from over in column A. (PC location codes are C, S, H, F, amp; O -- so all
gt; N/A's
gt; gt; for C, all N/A's for S, etc).
gt; gt;
gt; gt; To confirm, I want to compare the codes in column F against data in column
gt; gt; A, and count each N/A encountered, for each separate code.
gt; gt;
gt; gt; Per a previous suggestion, I tried using
gt; gt; =SUMPRODUCT((A1:A1000=quot;Cquot;),(F1:F1000)=quot;N/Aquot;), but it didn't work. I
gt; gt; shouldn't say they didn't work, but the results all come back as quot;0quot; and I
gt; gt; know none of the results should equal zero.
gt;
gt; The formula should be
gt;
gt; =SUMPRODUCT(--(A1:A1000=quot;Cquot;),--(F1:F1000=quot;N/Aquot;))
gt;
gt; and this assumes a text of N/A, not a #N/A as a result of a formula.
gt;
gt; gt; 2) Column O (O4:O8): This should show individual totals for various PC
gt; gt; location codes found in column F that are gt; 5000, but lt;=50000. (PC
gt; location
gt; gt; codes are C, S, H, F, amp; O -- so all instances of gt; 5000, but lt;=50000 for
gt; C,
gt; gt; all instances of gt; 5000, but lt;=50000 for S, etc).
gt; gt;
gt; gt; For this I tried using
gt; gt; =SUMPRODUCT((A1:A1000=quot;Cquot;),(F1:F1000)gt;5000,(F1:F10 00)lt;=50000), but as in
gt; the
gt; gt; case above I got back quot;0quot; as my results and I shouldn't have.
gt;
gt; Syntax again
gt;
gt; =SUMPRODUCT(--($A$1:$A$1000=quot;Cquot;),--($F$1:$F$1000gt;5000),--($F$1:$F$1000lt;=5000
gt; 0))
gt;
gt;
gt; gt; 3) Column P (P4:P8): This should show individual totals for various PC
gt; gt; location codes found in column F that are gt; 50000. (PC location codes are
gt; C,
gt; gt; S, H, F, amp; O -- so all instances of gt; 50000 for C, all instances of gt;
gt; 50000
gt; gt; for S, etc).
gt;
gt; Is that not simply
gt;
gt;
gt; =SUMPRODUCT(--($A$1:$A$1000=quot;Cquot;),--($F$1:$F$1000gt;5000))
gt;
gt;
gt;

I will, and you have one too lt;Ggt;

Bob

quot;MABquot; gt; wrote in message
...
gt; Woohoo!
gt;
gt; They worked. Thank you very much.
gt;
gt; Have a great day!
gt;
gt; MAB
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt;
gt; gt;
gt; gt; quot;MABquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I put in a question about this the last couple days, and I got some
gt; gt; answers,
gt; gt; gt; but due to my poor explanation, the info provided didn't work.
gt; gt; gt;
gt; gt; gt; I'll try again... :-)
gt; gt; gt;
gt; gt; gt; I would like to know if the following is possible:
gt; gt; gt;
gt; gt; gt; 1) Column N (N4:N8): This should show individual totals for various
PC
gt; gt; gt; location codes found in column F that corresponds with an N/A in the
same
gt; gt; row
gt; gt; gt; from over in column A. (PC location codes are C, S, H, F, amp; O -- so
all
gt; gt; N/A's
gt; gt; gt; for C, all N/A's for S, etc).
gt; gt; gt;
gt; gt; gt; To confirm, I want to compare the codes in column F against data in
column
gt; gt; gt; A, and count each N/A encountered, for each separate code.
gt; gt; gt;
gt; gt; gt; Per a previous suggestion, I tried using
gt; gt; gt; =SUMPRODUCT((A1:A1000=quot;Cquot;),(F1:F1000)=quot;N/Aquot;), but it didn't work. I
gt; gt; gt; shouldn't say they didn't work, but the results all come back as quot;0quot;
and I
gt; gt; gt; know none of the results should equal zero.
gt; gt;
gt; gt; The formula should be
gt; gt;
gt; gt; =SUMPRODUCT(--(A1:A1000=quot;Cquot;),--(F1:F1000=quot;N/Aquot;))
gt; gt;
gt; gt; and this assumes a text of N/A, not a #N/A as a result of a formula.
gt; gt;
gt; gt; gt; 2) Column O (O4:O8): This should show individual totals for various PC
gt; gt; gt; location codes found in column F that are gt; 5000, but lt;=50000. (PC
gt; gt; location
gt; gt; gt; codes are C, S, H, F, amp; O -- so all instances of gt; 5000, but lt;=50000
for
gt; gt; C,
gt; gt; gt; all instances of gt; 5000, but lt;=50000 for S, etc).
gt; gt; gt;
gt; gt; gt; For this I tried using
gt; gt; gt; =SUMPRODUCT((A1:A1000=quot;Cquot;),(F1:F1000)gt;5000,(F1:F10 00)lt;=50000), but as
in
gt; gt; the
gt; gt; gt; case above I got back quot;0quot; as my results and I shouldn't have.
gt; gt;
gt; gt; Syntax again
gt; gt;
gt; gt;
=SUMPRODUCT(--($A$1:$A$1000=quot;Cquot;),--($F$1:$F$1000gt;5000),--($F$1:$F$1000lt;=5000
gt; gt; 0))
gt; gt;
gt; gt;
gt; gt; gt; 3) Column P (P4:P8): This should show individual totals for various
PC
gt; gt; gt; location codes found in column F that are gt; 50000. (PC location codes
are
gt; gt; C,
gt; gt; gt; S, H, F, amp; O -- so all instances of gt; 50000 for C, all instances of gt;
gt; gt; 50000
gt; gt; gt; for S, etc).
gt; gt;
gt; gt; Is that not simply
gt; gt;
gt; gt;
gt; gt; =SUMPRODUCT(--($A$1:$A$1000=quot;Cquot;),--($F$1:$F$1000gt;5000))
gt; gt;
gt; gt;
gt; gt;