Try this:

items both billed and received

I'm assuming that means both fields have an entry.

=SUMPRODUCT(--(A2:A5="one"),--(ISNUMBER(MATCH(B2:B5,{"server",370,470},0))),--(C2:C5<""),--(D2:D5<""))

Biff

"WiFiMike2006" wrote in message
...
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