I'm trying to compile two reports I use into one report with a summary. What I call my Job Log is a sheet that adds up daily costs and charges and it carries over daily my copying the sheet tab and editing the new sheet with minor changes using the 'move or copy<move to end, create copy' option. What I am scavenging off of another report is a Monthly Summary that will take references from each one of these daily and compiles it into an easier to read format for other reports I send off.
So I'm going to write out the formula in general description and i'm looking for someone to translate it to the proper function. Any input would be helpful. Thank you.
=IF(cell D5 on sheet '9-1-14' reads "Personnel Only" [value if true is (reference cell J25's value) (if false mark 0)
This formula is sourced from the Month in Summary sheet and is referencing the first day of the month sheet then will be carried over to the following days until the end of the month. If this is flat out un-doable in this structure, what can I do to make it work?
Bookmarks