Calculate cells based on multiple criteria

Trying to calculate cells based on multiple criteria and have run into a block. I've attached the file as well as copied it here.
Using Excel 2003
If columnD=Billable and column E is not #N/A, multiply column C by column G

Project Name Total Time User 2 Team Dept Rates
Project1 User1 116.00 BILLABLE CS_BA B06 $76.50
Project2 User2 5.00 BILLABLE CS_BA BB9 $76.50
Project3 User3 21.50 BILLABLE CS_PMO BD2 $92.75
Project4 User4 3.50 BILLABLE CS_PMO BD2 $76.50
Project5 User5 1.00 BILLABLE Acct_Mgmt B06 $76.50
Project6 User6 31.00 BILLABLE CS_PMO BD2 $76.50
Project7 User7 13.50 BILLABLE CS_PMO BD2 $92.75
Project8 User8 0.75 BILLABLE Acct_Mgmt B06 $92.75
Project9 User9 5.40 BILLABLE CS_BA BB9 $92.75
Project10 User10 3.50 BILLABLE #N/A #N/A $92.75
Project11 User11 1.00 BILLABLE #N/A #N/A $76.50

Use

=IF(D4="Billable",IF(NOT(ISNA(E4)),C4*G4,0),0)

Hi Jealkon,

Perhaps try:

=IF(AND(D4="BILLABLE",NOT(ISERROR(E4))),C4*G4,0)

Fill that down as many rows as necessary.

for each individual row:

=IF(AND(D4="BILLABLE",ISTEXT(E4)),C4*G4,"")

for total sum

=SUMPRODUCT(--($D$4:$D$14="BILLABLE"),--ISTEXT($E$4:$E$14),$C$4:$C$14,G4:$G$14)

In cell h4 enter this formula and copy down

=IF(ISERROR(IF(AND(D4="BILLABLE",E4<>"#N/A"),C4*G4,"")),"",IF(AND(D4="BILLABLE",E4<>"#N/A"),C4*G4,""))