jjramirez85
New Member
- Joined
- May 21, 2014
- Messages
- 19
I am attempting to sum if the blank cells from another workbook across sheets 1 through 10 when column A:A (below) matches matches column F:F (other workbook) and row B:B (below) matches E17 (other file).
I could sumif one column at a time, and change the sheet reference manually, but there are about 75 columns, Any idea of a solution?
<tbody>
</tbody>
I could sumif one column at a time, and change the sheet reference manually, but there are about 75 columns, Any idea of a solution?
File |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
Department |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
Expense Type 1 | ||||||||||
Expense Type 2 | ||||||||||
Expense Type 2 | ||||||||||
Expense Type 4 | ||||||||||
Expense Type 5 |
<tbody>
</tbody>