Hi
in the attached sheet, the values highlighted in yellow, obtained with =SUMPRODUCT(--(B4:H4=TODAY())) should return 1 in cells H4 and H5 but return 0 although today's date is present in both rows ?
Thanks for any help
Hi
in the attached sheet, the values highlighted in yellow, obtained with =SUMPRODUCT(--(B4:H4=TODAY())) should return 1 in cells H4 and H5 but return 0 although today's date is present in both rows ?
Thanks for any help
Ok, got it, it's due to the circular references. I corrected that and it's OK
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks