Can I set the criteria in a sumif statement as a cell reference?

G

Guest

I am trying to use the sumif statement in excel and want to set the criteria
to a "less than" date. The only way I can get the formula to work is by
hardcoding the date into the sumif statement i.e
=sumif(A1:II1,"<31-OCT-05",A2:II2). However I want to copy this formula using
a number of different dates and do not want to individually hard code the
date. I want to replace the hard coded date with a cell reference that
contains the date. When I do this I get the microsoft excel pop up box
telling me there is an error in my formula.
 
G

Guest

Hi Duncan,

How about =SUMPRODUCT(--(A2:A4>F1),B2:B4) where A2:A4 contain the dates, F1
contains the referenced date cell and B2:B4 the values.
 
E

Excelenator

I used this formula

=SUMIF(A1:A9,D2,B1:B9)

Where Cell D2 was formatted as a date and I input "<2/27/1991" into
that cell just as it appears without the quotes and the sum worked.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
How can I define date range criteria in SUMIF formula? 1
Sumif Question 1
Specifying comparision criteria with SUMIF() 2
SumIf criteria can't be less than a cell reference 1
Multiple SUMIF Criteria 3
How do you reference another cell in the criteria of a SUMIF funct 2
SUMIF criteria 4

Top