billed and received may not both have a quantity entered. either/or could be
blank. but the idea is to count items billed that were also received. so if
billed is 2 and received is 4, only a count of 2 should be returned.

also, i think you might have forgotten the sheet! reference in the formula
since the data will be pulled from a different sheet (named "POs").

and one other thing. i need to search for text *contained* in the items list
since the list is item descriptions like "dell server" or "dell precision
370". the items won't be an exact match to the text string. Can wildcards be
used in this formula?

Please respond.

Thank you,
Mike

"T. Valko" wrote:

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