Help with Conditional SUMIF Formula

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
 
T

T. Valko

One way...

=SUMIF(A2:A13,">="&DATE(2010,1,1),B2:B13)-SUMIF(A2:A13,">"&TODAY(),B2:B13)
 
T

T. Valko

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. :)
 

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

conditional formatting: multiple conditions with min 0
help on a formula (match and etc..) 1
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
conditional formatting & formula 4
Lookup value on a table?? 4
Help with Formula 2
SumIf conditional to date range 5
What should formula look like to define date range on SUMIF 2

Top