jimstrickland

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.

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.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Thanks. The first formula was exactly what I needed.

ASKER