Monthly view of costs.xlsx
Attached is a file that contains 2 worksheets: Data and Monthly
The Data sheet contains data that shows the total amount for a data range per Batch and Type.
The Monthly sheet lists each unique entry of Batch and Type. I need a formula to enter into cells (C2-CH10) that will calculate those total costs on the Data sheet into the monthly amount and discplay that amount into those cells. I've hard entered the amounts the formula should return.
Thanks for any assistance.
Bookmarks