Re: $$Excel-Macros$$ Sum Product with Time

Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Sep 12, 2014 at 3:58 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Thanks a lot > > On Fri, Sep 12, 2014 at 3:06 PM, Vaibhav Joshi wrote: > >> Chk this.. >> >> Cheers!! >> >> + >> *I di

Re: $$Excel-Macros$$ Sum Product with Time

Thanks a lot On Fri, Sep 12, 2014 at 3:06 PM, Vaibhav Joshi wrote: > Chk this.. > > Cheers!! > > + > *I did not do this for you. God is here working through me for you.* > > On Fri, Sep 12, 2014 at 12:19 PM, Chandra Shekar < > chandrashekarb@gmail.com> wrote: > >> Hello Vaibhv, >> >> It

Re: $$Excel-Macros$$ Sum Product with Time

Chk this.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Fri, Sep 12, 2014 at 12:19 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello Vaibhv, > > It seems formula is wrong count should be 4 but its giving as 7. Could you > please check it

Re: $$Excel-Macros$$ Sum Product with Time

Dear Chandrashekar, Cells should not be empty. Append 0 and see . Warm Regards, Gawli Anil On Fri, Sep 12, 2014 at 12:19 PM, Chandra Shekar wrote: > Hello Vaibhv, > > It seems formula is wrong count should be 4 but its giving as 7. Could you > please check it. > > Thanks in advance. > > Regard

Re: $$Excel-Macros$$ Sum Product with Time

Hello Vaibhv, It seems formula is wrong count should be 4 but its giving as 7. Could you please check it. Thanks in advance. Regards, Chandru On Thu, Sep 11, 2014 at 8:34 PM, Vaibhav Joshi wrote: > chk this... > > > Cheers!! > > + > *I did not do this for you. God is here working through

Re: $$Excel-Macros$$ Sum Product with Time

chk this... Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Sep 11, 2014 at 8:23 PM, Chandra Shekar < chandrashekarb@gmail.com> wrote: > Hello, > > Could you please let me know what is the issue with sumproduct formula > where result should be 3

Re: $$Excel-Macros$$ Sum Product

Thanks a lot.. On 2/8/12, NOORAIN ANSARI wrote: > *Learn:* > >- Introduction to SUMPRODUCT > Formula >- Advanced SUMPRODUCT Formula > Examples >- Introduction

Re: $$Excel-Macros$$ Sum Product

*Learn:* - Introduction to SUMPRODUCT Formula - Advanced SUMPRODUCT Formula Examples - Introduction to SUMIFS Formula

Re: $$Excel-Macros$$ Sum Product Sheet

Hi, Please find some more example on sum product. Regards Chethan Kumar BN On Tue, Oct 18, 2011 at 10:59 AM, ashish koul wrote: > http://www.bygsoftware.com/Excel/functions/sumproduct.htm > > http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/ > > http://www.exceluser.com/explore/sumpro

RE: $$Excel-Macros$$ Sum Product use in Macro

Hi, It seems that Sumproduct doesn't work as expected in VBA. I have found that I need to use 'Evaluate' So, if your worksheet formula was, for example: SUMPRODUCT((A2:A200="Yes")*(B2:B200)) Then the VBA equivalent would be: YourVariable = Evaluate("SUMPRODUCT((A2:A20=""Yes"")*(B2:B20))") Note th