Help with Conditional SUMIF Formula

  • Thread starter Thread starter SanCarlosCyclist
  • Start date Start date
S

SanCarlosCyclist

Hi, I would like your help in creating a conditional SUMIF formula. I
want to sum column B if column A is between 1/1/10 and today. Below is
an example of the data. Any suggestions?

Today 4/17/2010
Desired Result = $3,183

Col A Col B
1/1/10 $804
2/1/10 $799
3/1/10 $793
4/1/10 $788
5/1/10 $783
6/1/10 $777
7/1/10 $772
8/1/10 $766
9/1/10 $761
10/1/10 $755
11/1/10 $750
12/1/10 $744
 
You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


One way...

=SUMIF(A2:A13,">="&DATE(2010,1,1),B2:B13)-SUMIF(A2:A13,">"&TODAY(),B2:B13)
Click to expand...

It worked. Thanks so much T. Valko. :)
 
Back
Top