Excel 2007 spreadsheet SUMIF formula, need help! This is driving me crazy!!!?
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
very simple.

instead of using date as 'formated' date, use it as numeric numbers. excel behaves anything in numbers. once you convert the numbers, bring the year on the left, and insert another function before you actually concatinate (wild card) the year and use the result to apply the same formula.

ARE YOU FINDING IT DIFFICULT TO CONCEIVE WORRY NO MORE BECAUSE DOCTOR
CLIMENT SCOTT IS HERE TO HELP YOU WITH HIS HERBAL HERBS NOW DO TRY AND
CONTACT HIM AM A LEAVING TESTIMONY....

I am singing with joy today because of what God has use Doctor climent Scott to
do in my life,can you believe I got pregnant at the age of 40 year,i have
be looking for a baby of my own that will call me mother for the past
7years, I contacted some many people who try their best but there was no
solution to my problem, but when I came in contact with Dr climent Scott my
story change from worst to the best,so many people think that I will never
have a baby of my own,but when Drcliment scott gave me his powerful pregnancy
herbal herbs I became pregnant after taking it for just one month all I did for
him was to get the herbs which she told me to get and now I have a child I
could call my own,i am so happy, you can contact him via email >>>
( [email protected] [email protected] ) and +2347036879479 +2347036879479