LinkBack URL
About LinkBacks
Probably Sumproduct will do
=Sumproduct(--(aaa=1),--(bbb<=DATE(2004,10,29)),--(bbb>=DATE(2004,9,25)),ccc)
Probably Sumproduct will do
=Sumproduct(--(aaa=1),--(bbb<=DATE(2004,10,29)),--(bbb>=DATE(2004,9,25)),ccc)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I tried it and it gave me #NUM!.Is there anything in my data formatting that would cause this problem?
The ranges cannot be whole columns, eg. A:A if you are not in XL2007Originally Posted by kgibson20
Worked like a charm. TYVM
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks