So I have a ledger sheet that was set up to record costs for a single project. We've added a project column so we can track more than one project so every entry (row) now is identified per project. I'm already running some
SUMIF functions to total a column if another column matches a criteria, but I now need to add in another criterion...
My existing formula sums column J where column E = "sometext"
=Sumif(Ledger!$E$7:$E$900, "Amberon", Ledger!$J$7:$J$900)
How can I expand this to sum only when two columns match?
My newly added project identifier is column
Ideally, I'll only have one set of sum values but will select which project they apply to based on the value in a cell with a picker (List of projects).
I've read about
SUMIFS but can't seem to understand the syntax.