May 19 2020 07:42 AM
Hi all. This might sound like an amateur question. I have a very long data record of how much I get paid for business purposes and I record them on a daily basis with reference to the date. I want to know if there's a formula for me to sum up the income monthly. For now, I manually select the income from the beginning of each month until the end of the month to sum them up but I think it would be easier if there's a formula for it. I'll attach the file here as well for your reference. Thanks in advance.
May 19 2020 07:48 AM
Solution@Turu96 here you go,
I have added an extra column - "Calculation column", please don't delete it
Function used: SUMIF
May 19 2020 08:13 AM
@bhushan_z Thanks a lot bro. Now I've learned something new.
May 19 2020 07:48 AM
Solution@Turu96 here you go,
I have added an extra column - "Calculation column", please don't delete it
Function used: SUMIF