Re: $$Excel-Macros$$ Re: Count multiple criteria in a column with the help of VBA

thanks bhai But want to solution in VBA. On Thu, Sep 13, 2012 at 10:49 AM, Prince Dubey wrote: > Hi Jeet, > > Please use below formula hope this will helpe you. > > > =SUM(SUMPRODUCT((Sheet1!$A$1:$A$2270=A2)*(Sheet1!$B$1:$B$2270=12)),SUMPRODUCT((Sheet1!$A$1:$A$2270=A2)*(Sheet1!$B$1:$B$2270=13)))

$$Excel-Macros$$ Re: Count multiple criteria in a column with the help of VBA

Hi Jeet, Please use below formula hope this will helpe you. =SUM(SUMPRODUCT((Sheet1!$A$1:$A$2270=A2)*(Sheet1!$B$1:$B$2270=12)),SUMPRODUCT((Sheet1!$A$1:$A$2270=A2)*(Sheet1!$B$1:$B$2270=13))) use it with Ctr+Shift+Enter Regards Prince On Wednesday, September 12, 2012 11:52:11 PM UTC+5:30, jeet