View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AC-H
 
Posts: n/a
Default Joining 2 SUMIF's ???

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??