Link to home
Start Free TrialLog in
Avatar of jimstrickland
jimstricklandFlag for United States of America

asked on

I need Excel formula that is sum based on multiple criteria ranges

I am having difficulties with coming up with a correct formula. I need a formula that says to sum F12:F106 with the following two criterias.

1.  criteria range of C12:C106 and criteria 36

2. criteria range of D12:D106 criteria of date is greater than 12/31/2012 and less than 1/1/2014

I am doing fine all the way up through the first criteria. The date formula is what is giving me fits.
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jimstrickland


This is Office 2010. Your first formula worked perfectly. Thanks.
Thanks. The first formula was exactly what I needed.