Writing IF functions where 'Logic Test' is text string and 'value true' is cell reference

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?

Please Login or Register  to view this content.

This will look at cell D5 on sheet 9-1-14 and check if it is filled with the text string "Personnel Only"
TRUE: pull over whatever is in cell J25 on the same sheet as this function
FALSE: return zero

I just noticed an error in my parameters. I entered my data in the format you have above but got a #VALUE. This may be because the "J25" is also on the referenced page and will be pulled back to the page with the formula on it. I attached snips of the two pages if this would help at all.Excell capture.PNGexcell capture 2.PNG