In the attached workbook on the UCA Data Input Sheet, column "I", cell I6, the formula is returning a result of 5,983. It should be returning 0. This is particularly baffling since identical formulas in the rest of the cells in column I work perfectly.
What could possibly be going on?
Last edited by Steve Collins; 07-02-2010 at 11:19 AM.
Excel regards empty cells as January dates so you can to introduce another condition to check that the date cells aren't blank, i.e.
=SUMPRODUCT(--(TEXT('Definitized UCAs'!$L$3:$L$6000,"mmm")='UCA Summary Data'!E19),--('Definitized UCAs'!$L$3:$L$6000<>""),--('Definitized UCAs'!$G$3:$G$6000<180))
Audere est facere
Thanks so much. It now works just fine.
I am not sure why that was the only formula that did not work when all of the other ones in the same column did work. That cell is the only one that referred back to a cell containing the text "Jan" so that must have had something to do with it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks