Basically, I am trying to create a formula that would sum the numbers in one
column should the next column have a specific date. For example, i would
like to sum all numbers in column X if a row in column A has "Sept" or "Nov".
here is my formula so far. what this will obviously do is SUM the column
C2:C14 if ANY row in column E is labeled "Sept". i hope i making this as
clear as possible.

=IF(E2:E14="Sept", SUM(C2:C14),0)

the 0 in the end of the formula is just temporary, i was having the formula
place a 0 if the formula didn't find "Sept" in column E.

thanks for any help or tips!

Paul