Hi,

The sumproduct function should work fine - I have tried it. If you are
using the * operator, you need not use --. I worked with the following
example in range J18:K21

ICDS SCG
RTE SCG
ICDS SCG
FGH SCG

=SUMPRODUCT((J18:J21="ICDS")*(K18:K21="SCG")) and the answer is 2

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Annie" wrote in message
...
I need help with the following: I am working in a workbook that was
created
by someone else. The summary tab is built using Insert Define Name to
extract
information from the source tab (OppDB). On a separate tab, I need to
extract the number of products and Factored MRR for specific groups. I've
tried to use what was already built: =DSUM(OppDB,"Factored MRR", P1:P2)
and
it's not working P1:P2 houses the specific group.

I've also tried the following:
=SUMPRODUCT(Opportunity!E3:E135="ICDS")*(Opportuni ty!C3:C135="SCG")
=SUM(IF($B$1=Segment, IF(Products=A3, Count)))

With the above formulas I'm attempting to count the number of products
(ICDS) for a specific group (SCG), independently of what has already been
done. Opportunity is the tab that houses the source data.

Any assistance will be greatly appreciated!
--
Thanks In Advance, Annie