Is this "Driller" ?

<G

Biff

"WiFiMike2006" wrote in message
...
Cool. THANK YOU!

Just one more question, can I use a wildcard to search for text
*contained*
in the item list in this formula? For example:

=SUMPRODUCT((SheetA!A2:A10="one")*(SheetA!B2:B10={ "*server*","*370*","*470*"})*(SheetA!C2:C10+SheetA !D2:D10))

...because, in reality, the items column is a bunch of item descriptions
with stuff like "Dell Precision 370" or "Dell server quote" in them. They
aren't as simple as just a one word description.

Also, I need to test this formula you gave still. I'm not sure, but it
looks
like it will add the received and billed quantities for each item, instead
of
adding quantity of items billed that were also received. For example, if
received = 0, and billed = 2, i wouldn't want it to count 2, I would want
it
to count 0. If received = 2 and billed = 1, it should count 1. If
received =
4 and billed = 2, it should count 2. Basically, it should count quantity
billed that are also received. Understand?

Thanks,
Mike

"RagDyer" wrote:

Try this:

=SUMPRODUCT((SheetA!A2:A10="one")*(SheetA!B2:B10={ "server",370,470})*(SheetA!C2:C10+SheetA!D2:D1 0))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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