I wrote the following formula...
=SUMIF('AP-24X7'!$P:$P,"="&(TEXT(C$5,"mmm-yy")),'SP-24X7'!$L:$L)
It pulls the data I need like a charm,however it doesn't know how to pull only entries exclusive to my object codes. How would I stack a second argument into the formula to make it not only recognize the date but also be "True" to the object code specified?
Bookmarks