Sum values depending on a specific month

[fapb48]

Hi,

I am building a spreadsheet to track income of a service that i am doing.

I have many tabs... each tab for a week of income on a daily basis.

I have a master sheet that tracks the total income of each spreadsheet.

But i want to add on my master sheet a column where i can track what i have earned each month.

I am using sumif and i am guessing that i need to use the date function with it, but it asks me the year and the day as well as the month. but i only want to track the month.

This is the formula that i am using

=SUMIF(Payment1!A:A DATE(), Payment1!B:B)+SUMIF(Payment2!A:A DATE(), Payment2!B:B)

What should i just add into the function to only look at the specific month and nothing else? in this example i wanted to track the Month of March

Thank you

 

[mabbutt]

You can use the Month function to look at a specific month.