=sumproduct(--(countryrng=countrycriteria),--(opprng=oppcriteria),revrng)

=sumproduct() likes to work with numbers. the -- stuff converts trues and
falses to 1/0's.



AC-H wrote:

How can I join the following SUMIF's in to a single formula? Please help my
heads about to blow up :)

=SUMIF(Country range, country criteria,revenue range)
=SUMIF(Opportuntity range, Opp criterion, revenue range)

Need to apply both criterion to the SUM revenue range. How do I do this??

--

Dave Peterson