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...

For example:

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 Ledger!$A$7:$A$900

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.

1 Answer 1


=SUMIFS(A1:A17, B1:B17, "Dragon",
                C1:C17, "Kate")


  • I think I understand this - I'll give it a try - Thanks.
    – Peter Kay
    Jan 12, 2019 at 13:40
  • Can you help with the syntax if the test is another cell rather than text in " "? so Lookups!C4 whose content is a drop down picked from a list? This will mean we can have a single tab whose content is the product of SUMIfs with a drop down to select one of the criterion.
    – Peter Kay
    Jan 12, 2019 at 13:43
  • yes, you can make dynamic criterion from dropdown list too
    – user0
    Jan 12, 2019 at 14:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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