How to fix Excel problems? I have some easy questions for you, just like a beginner who is new to spreadsheets!
How to fix Excel problems? I have some easy questions for you, just like a beginner who is new to spreadsheets!
So here is how it works: Col A holds the Date, Col B has the Amount, and Col C shows the numeric Month linked to the date. You can use =SUMIF(C:C, 11, B:B) to add up numbers only if Column C matches 11. If you want, you could also include a MONTH function to grab the month value directly instead of using dates.