0

So I have run into an issue... This maybe simple, but I just can't figure it out.

On a spreadsheet on Google Sheets, I need for a cell to populate a total when a certain cell contains another variable.

So I want the money spent in 2020 row to only pickup the dollar amount in the "Money" column that contains the date 2020 (or 20 for that matter) in the "Date" column.

enter image description here

Thank you in advanced!

0

With sumifs

=SUMIFS(E2:E10,A2:A10,">31/12/2019",A2:A10,"<01/01/2021")

With If

=sum(arrayformula(If(year(A2:A10)=$J$2,E2:E10,)))

where A is the Date column, E the Money column, and $J$2 is the 2020

  • Thank you so much...this was really bothering me! I have just dipped my foot into this Sheets/Excel stuff. Thank you once again! – Daniel Mathews Feb 16 at 0:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.