In a solution here I saw the following:
=SUMPRODUCT(--(TEXT($B$3:$C$184,"ddd")=M2))
I don't know what the double-dash between the open parens is, or does, and can't find it via help.
Can you offer or point me toward an explanation?
Thanks
In a solution here I saw the following:
=SUMPRODUCT(--(TEXT($B$3:$C$184,"ddd")=M2))
I don't know what the double-dash between the open parens is, or does, and can't find it via help.
Can you offer or point me toward an explanation?
Thanks
Last edited by excelname; 06-02-2010 at 10:48 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks