Need help counting and summation values associated with text

[DonAdrian.needs.help]

Hello All (long time listener, first time caller...)

I could use some help with a formula involving the summation of monthly expenditures. I couldn't find a related thread so it i decided to post my question.

I have a spreadsheet where i have tracked month expenses for multiple contracts, and i am trying to figure out the formula that sums the monthly values associated with the 'original' contract. So my data would look as follows... (for some reason the space between 'contract' and 'value' does not appear as I typed it, so just know there is space between the two.)

Contract Value
Jun $10
Jun Mod 7 $7.5
Jun Mod 8 $3.2
Aug $9.22
Aug Mod 7 $12.1
Aug Mod 9 $5.5

Reading through the forum i figured out how to count and sum contracts that have a number (e.g. Mod 7, 8 or 9) via SUMIF(criteria, "*Mod 7*", [criteria range]). Learning the use of "*" was key. However, i need to be able to count the summation of the values associated with "Jun" + "Aug" + "Sep" ...

I was trying to add an "OR" or "AND", but i was going nowhere, fast. The last tidbit is the Months are text and not numbers formatted for months.

Anyone got this?

much thanks,
Adrian

[DonAdrian.needs.help]

Sorry i forgot to mention if the obvious answer is the only answer. do i have to use the SUMIF formula 12 times - one for each month - or is there a way to include the 12 months in one formula.
thanks

[FDibbins]

are all the months on the same worksheet, or 1 sheet per month?

perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[FDibbins]

are all the months on the same worksheet, or 1 sheet per month?

perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.