View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
paul paul is offline
external usenet poster
 
Posts: 4
Default How to make a nested SUMIF possible

I am trying to sum a column ("S") based on fulfilling 2 criteria in 2
other columns (C = A1 AND O = 1, 2, 3...12). I want to do this in a
formula rather than a DSUM since my criteria changes in 2 different
ways; Column C follows a cell reference, and Column O follows months 1
- 12.

Suggestions?