basic spreadsheet

[JONNEWBY]

hey guys im a newby just started programing,



i have a basic spreadsheet with following fields:

date
time
make
model

heres my ?

i just want to sum all the cells with the same month, so far i have negative results....
can you guys bail me out?

thanks in advance

 

[Tom Urtis]

Because you are framing your question around programming, have you considered turning on the macro recorder, creating a pivot table based on your data, and getting your information that way, it sounds like a pivot table would get you the kind of monthly synopsis you want.

 

[CPM350Z]

What field do you want to sum? Or do you just want a count of all the cells with the same month?
If that is what you want then insert a line below the date row with the formula =Month(A1) and somewhere else on the sheet (in this example B10:B21) enter the numbers 1 to 12 and enter the formula =COUNTIF($B$2:$B$XX,B10) in C10:C21.

This should give you the result you want. I'm sure there's an easier way too.