SOLVED

Calculate monthly sum

%3CLINGO-SUB%20id%3D%22lingo-sub-1402665%22%20slang%3D%22en-US%22%3ECalculate%20monthly%20sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1402665%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all.%20This%20might%20sound%20like%20an%20amateur%20question.%20I%20have%20a%20very%20long%20data%20record%20of%20how%20much%20I%20get%20paid%20for%20business%20purposes%20and%20I%20record%20them%20on%20a%20daily%20basis%20with%20reference%20to%20the%20date.%20I%20want%20to%20know%20if%20there's%20a%20formula%20for%20me%20to%20sum%20up%20the%20income%20monthly.%20For%20now%2C%20I%20manually%20select%20the%20income%20from%20the%20beginning%20of%20each%20month%20until%20the%20end%20of%20the%20month%20to%20sum%20them%20up%20but%20I%20think%20it%20would%20be%20easier%20if%20there's%20a%20formula%20for%20it.%20I'll%20attach%20the%20file%20here%20as%20well%20for%20your%20reference.%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1402665%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1402686%22%20slang%3D%22en-US%22%3ERe%3A%20Calculate%20monthly%20sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1402686%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F672702%22%20target%3D%22_blank%22%3E%40Turu96%3C%2FA%3E%26nbsp%3Bhere%20you%20go%2C%3CBR%20%2F%3EI%20have%20added%20an%20extra%20column%20-%20%22Calculation%20column%22%2C%20please%20don't%20delete%20it%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFunction%20used%3A%20SUMIF%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1402793%22%20slang%3D%22en-US%22%3ERe%3A%20Calculate%20monthly%20sum%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1402793%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662966%22%20target%3D%22_blank%22%3E%40bhushan_z%3C%2FA%3E%26nbsp%3BThanks%20a%20lot%20bro.%20Now%20I've%20learned%20something%20new.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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.

2 Replies
Highlighted
Best Response confirmed by Turu96 (New Contributor)
Solution

@Turu96 here you go,
I have added an extra column - "Calculation column", please don't delete it

 

Function used: SUMIF

Highlighted

@bhushan_z Thanks a lot bro. Now I've learned something new.