E ExcelSur Member Nov 21, 2019 #1 Hello, I have 2 columns and I want to add both columns with in a date range. Thanks for your help Attachments Intuit to Odoo - Journal Entry.xlsx Intuit to Odoo - Journal Entry.xlsx 27.5 KB · Views: 5
N NARAYANK991 Excel Ninja Nov 21, 2019 #2 Hi , You already have formulas which can do this : Won't this do what you want done ? =SUMIFS(ee_taxes, start, ">=" & $B$3, end, "<= " & $C$3) + SUMIFS(er_taxes, start, ">=" & $B$3, end, "<= " & $C$3) Narayan
Hi , You already have formulas which can do this : Won't this do what you want done ? =SUMIFS(ee_taxes, start, ">=" & $B$3, end, "<= " & $C$3) + SUMIFS(er_taxes, start, ">=" & $B$3, end, "<= " & $C$3) Narayan
E ExcelSur Member Nov 22, 2019 #3 NARAYANK991 said: Hi , You already have formulas which can do this : Won't this do what you want done ? =SUMIFS(ee_taxes, start, ">=" & $B$3, end, "<= " & $C$3) + SUMIFS(er_taxes, start, ">=" & $B$3, end, "<= " & $C$3) Narayan Click to expand... Thanks Narayan. Didnt know that we can add 2 sumifs functions. Thanks for your help
NARAYANK991 said: Hi , You already have formulas which can do this : Won't this do what you want done ? =SUMIFS(ee_taxes, start, ">=" & $B$3, end, "<= " & $C$3) + SUMIFS(er_taxes, start, ">=" & $B$3, end, "<= " & $C$3) Narayan Click to expand... Thanks Narayan. Didnt know that we can add 2 sumifs functions. Thanks for your help
