I have an Excel spreadsheet that I need to add up sales within each month.
There are 2 columns, one column with the full date (12/01/09 format) and one with the sale amount. What formula can I use to add up all the December sales?
So far I have: =SUMIF(A1:A3, "12/?/09", B1:B3) I'm just getting stuck on the criteria part to count all the Dec ones.
Here is a simplified version of my data (I have over 2500 sales to total throughout the year)
A B
1 12/01/09 $12.50
2 12/01/09 $5.50
3 12/05/09 $55.50
0