=SUMIF(B2:B13,"=Jan",C2:C13)

  • Thread starter Thread starter a921
  • Start date Start date
A

a921

I'm looking to use the "sumif" formula listed above.
However my data lists Jan-03 and Jan-04. How do I account
for the years in the above formula? Thanks in advance!!
 
If you want to sum January for both years and the data is actual text, not the
date Jan 1, 2003, formatted to show Jan-03,

=SUMIF(B2:B13,"Jan*",C2:C13)

note the wildcard.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

question about sum 2
Continuing Formula - try 3 1
using sumifs with multiple criteria? 3
Conditional sum, when condition has multiple values 3
Sumif formula 4
Filtering with SUMIFS 1
Sum if -- Sum_range across multiple columns 3
Receiving #VALUE! error for my average formula 2

Back
Top