How can I create a SUMIF statement with multiple criteria?
I have a spreadsheets where I track hours for different clients in one table, and below this table I want to summarize in a summary table the hours per client if that work is finished and if it is billable.
My Statement would say, SUMIF:
- Textfield ClientName = "InsertClientName"
- Checkbox for billable hours = TRUE
- Checkbox for finished work = TRUE
So in my imagination it would have to be:
How can I create a formula like this?
I have browsed the Apple Help Forums and StackExchange, but they mostly show SUMIF Statements with one criteria, or people use IFAND Statements and every row to use that in their SUMIF Statement, but my problem is that I will at least need two criteria in my summary table All hours of ClientX where the hours are checked as billable.
Looking forward to your answers.