Hi Everyone!
I am trying to automate a template so that when a company and labor category are selected, the rate will populate limiting a person from entering the wrong rate. Since there are 2 different criteria, I decided to use a SUMIFS formula =SUMIFS('Contract Rates'!D3:D119,'Contract Rates'!A3:A119,A10,'Contract Rates'!B3:B119,B10) which works but my problem is with blank cells. The format we send to our client does not have the company name listed next to every labor category and I would really like to keep it that way. Is there a way to tell cell D11 if cell A11 is blank, look at cell A10 for the company's name? I tried nesting an IF formula with it but it just put what was in cell A10 instead of looking for the rate so I removed it.
Attached is a workbook example. Any insight would be greatly appreciated!
Bookmarks