I want to use sumif to sum up a column based on a range of dates

  • Thread starter Ricky from Pine Island
  • Start date
R

Ricky from Pine Island

I would like to sum up a column of agent commissions using a range of dates.
For example: the agent has input all of his commissions for january 1, 2006
through april 30, 2007. I would like a sumif formula that sums up the
commissions for just the year 2006. Is this possible with sumif? I have
tried using >= and <= but it doesn't work.

Thank you, Ricky
 

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

Summing up cells based on names in adjoining cells - I'm new to using functions 2
Need Help with Sumif Function including dates 6
Use TODAY() function as the criteria in a SUMIF formula 1
SUMIF with criteria "<>" & "=" 4
Help on the Sumif Function 1
use month in cell date to sum all relevant cells 2
VLOOKUP or SUMIF for Multiple Criteria 2
How can I define date range criteria in SUMIF formula? 1

Top