Thread: Calculate total cost - multiply two values based on conditions in an array

This may be an easy one, but I do these so infrequently these days...

I have a chart of employees - both regular and contract. I want to estimate my yearly budget for contractors.

Each row beginning in row 3 is an employee. Columns are contract rate (B), then a column for each month (C - N) where I designate whether in that month the person was contract "C" or regular "R" (or blank if they weren't here that month).

In row 2 I have the number of work hours for each month.

So, I want to calculate the total contract cost for each person - if they were a contractor Jan-June and then hired, I multiply the total hours in Jan-June by their rate, then sum the results.

Hope I explained it well....

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!