Calculation trouble

[Mattimus]

For time keeping and invoicing I'm using the formula =SUM(FILTER(A_History, "A_History[Customer]=%",[Company Name])[Time Spent]) to total up all of the hours used by a specific company and it works great (I'm proud of myself for getting this far) But there is also another column called "Billable" with a simple "Yes" or "No" option. I would like to exclude any "no" line items from the calculation.
How do I go about doing that?
Here are some screen shots to help...
Here is the A_History table

And here is the A_Customers table

Thanks in advance!

[Kamran]

Hi @Matt-e8a3 Nice work!

You can add additional conditions by simply specifying AND or OR keywords between the conditions:

=SUM(FILTER(A_History, "A_History[Customer]=% AND A_History[Billable]=%",[Company Name], "Yes")[Time Spent])

BTW, since Customer is a rowlink in your history table, you can also do:

=SUM(FILTER(A_History, "A_History[Customer]=Thisrow() AND A_History[Billable]=%", "Yes")[Time Spent])

Additional info on filters:

Filter( )

FILTER() Description FILTER( ) filters a table or filter and returns a reference to rows matching the criteria when set as a source for a list. Multiple conditions can be combined using AND or OR. Syntax =FILTER(table, "condition", [condition_parameters, ...]) Required Table/filter: A table or filter that returns a list of rows. Optional Condition : Specify one or more Boolean formulas as a condition. Conditions can contain any supported functions Condition is expressed as a quoted st…

And Thisrow()

ThisRow( )

THISROW() Description THISROW() returns a rowlink to where the formula is executed. THISROW works in any row in a table, or in any list in an app. By itself it may not seem very useful, but when used in the context of other formulas or in app navigation it proves to be quite powerful. Syntax =THISROW() Does not take any input parameters. Example Let’s say you have a “Status” table with rows for “Red”, “Yellow” and “Green”. Let’s also assume that you have a “Projects” table which has a “Statu…

[Mattimus]

Oh, I see what you did there. That's excellent! Thank you! I ended up using ThisRow() option since it seems to be more versatile.
I'm definitely new to all this (I don't even know how to program) But HoneyCode has made it so I can do some incredible things! Thank you very much for being awesome and supporting newbies like me