Have a function in mind, but don't know how to do it

[John]

Ok, so I have a simple workbook put together that looks like this:
.... [Client Chargeable Hours]...[Hours Worked]

Tha client chargeable hours will be a Yes/No value. The [Hours Worked] will
be a regular hh:mm format

What I want to do now is to set up 2 separate totals. I need a function that
would filer all rows #4-99. If the value in cell for [Client Chargeable
Hours] is Yes, than I need the [Hours Worked] value from the corresponding
cell in that row to be added to the Client chargeable total. If the value is
No, than I need that value to be added to Non-client chargeable total.

All of this I want them to be programmed as a function, so the "update" is
live.

I am not sure how to set this up for a list, and what function to use.

Thanks for your help guys, I appreciate it!

~John

 

[Dave R.]

How about something like this;

=SUMIF(A1:A10,"yes",B1:B10)

where A1:A10 holds "yes" or "no" and B1:B10 is the hours worked. Change
"yes" to "no" for non chargeable hours.

 

[John]

Dave,

It worked great! THANK YOU!

~John

How about something like this;

=SUMIF(A1:A10,"yes",B1:B10)

where A1:A10 holds "yes" or "no" and B1:B10 is the hours worked. Change
"yes" to "no" for non chargeable hours.

Ok, so I have a simple workbook put together that looks like this:
... [Client Chargeable Hours]...[Hours Worked]

Tha client chargeable hours will be a Yes/No value. The [Hours Worked] will
be a regular hh:mm format

What I want to do now is to set up 2 separate totals. I need a function that
would filer all rows #4-99. If the value in cell for [Client Chargeable
Hours] is Yes, than I need the [Hours Worked] value from the corresponding
cell in that row to be added to the Client chargeable total. If the value is
No, than I need that value to be added to Non-client chargeable total.

All of this I want them to be programmed as a function, so the "update" is
live.

I am not sure how to set this up for a list, and what function to use.

Thanks for your help guys, I appreciate it!

~John