How do I collect a sum with the following conditions(?):
If A:A = "AAA"
If D:D = "XXX"
then sum of all "XXX" that also are "AAA" (i.e., appear in the same row as
"AAA")

Along the same lines consider also:
If A:A = "AAA" and,
If C:C = "BBB" and,
If D:D= "XXX" then,
sum of all "XXX" that are also "AAA" and "BBB" when "AAA" and "BBB" appear
in the same row with "XXX"

Thanks Jim