Thread
:
How to make a nested SUMIF possible
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
How to make a nested SUMIF possible
maybe
=sumproduct((c2:c22=a1)*(o2:o220)*(o2:o22<=12)*s2 :s22)
--
Don Guillett
SalesAid Software
"paul" wrote in message
oups.com...
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett