Hi,
This formula will fail to give correct result when you are matching
criterion for diff months..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Mon, Sep 15, 2014 at 4:41 PM, Mandeep Baluja
wrote:
> Use this if you have data for this month only small
Use this if you have data for this month only small and simple
=SUMPRODUCT(--((DAY($B$2:$B$15)=DAY(D2
Regards,
Mandeep baluja
On Friday, September 12, 2014 2:34:42 PM UTC+5:30, Chandru wrote:
>
> Hello,
>
> How to get unique values based on two conditions. Could you help me in the