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

G

Guest

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

Need Help with Sumif Function including dates 6
SUMIF function 3
SUMIF with criteria "<>" & "=" 4
How can I define date range criteria in SUMIF formula? 1
Sum a range based on two variables 2
use month in cell date to sum all relevant cells 2
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
Application hang with array sum(sumif... formula 7

Top