Forum Discussion
Solved
Accounting spreadsheet
Hi! I am using an excel sheet to track my transactions, and I'm trying to make it a little less work while inputting things. However, I can't seem to get a function to do the math I need. I'm t...
how about =SUM(FILTER(C3:D5,B3:B5="N"),0)
if you don't have excel 365 then maybe
=SUMIFS(C3:C5,B3:B5,"N")+SUMIFS(D3:D5,B3:B5,"N")or
=SUMPRODUCT(C3:D5*(B3:B5="n"))
how about =SUM(FILTER(C3:D5,B3:B5="N"),0)
if you don't have excel 365 then maybe
=SUMIFS(C3:C5,B3:B5,"N")+SUMIFS(D3:D5,B3:B5,"N")
or
=SUMPRODUCT(C3:D5*(B3:B5="n"))
