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