Posted to microsoft.public.excel.misc
|
|
Dcounting without doble counting
Check out this link...
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...
Jim Thomlinson
"Guidu" wrote:
imagine a range like this:
Actiondate volume
1-sep 2
1-sep 3
3-sep 5
5-sep 7
9-sep 6
etc
this constrains
Actiondate Actiondate
=1-sep <6-sep
I would like a function that counts the number of days between my contrain
that do not doble count de dates....in this example the answer would be 3
Thank you people very much....I am so gratefull for your help
|