i need to count data from sheet "A" based on several criteria and enter it on
sheet "B".

Sheet A:

a b c
d
1 site item received
billed
2 one server 2
1
3 one 370 1
2
4 one 470 1
1
5 two server 1
1

For this example, i need to count only the total quantity of items both
billed and received for any occurrence of either "server", "370", or "470"
listed in sheet A where the "site" is listed as "one".

For this example, the formula's result would be 3, since only 3 were billed
and received for site one.

PLEASE HELP! Counting all this data manually for over 100 items and over 30
projects is taking me WEEKS to complete.

Thank you!

Mike