View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SavageMind SavageMind is offline
external usenet poster
 
Posts: 1
Default SUMIF with multiple criteria for multiple columns to sum a single

I have a large database. I want to use a SUMIF or similar command to search a
single column, then search again within those results under another criteria,
then either AVERAGE or SUM the another column based on those results.
The columns I'm searching (filtering) all have a repeated formula in them so
this needs to go in it's own cell(s) sepately and work.