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
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