Senin, 15 Oktober 2012

RE: [ExcelVBA] formula not working

 

I wonder if sumproduct must be for newer versions than I am using, (2000) because I could not get your suggestion to work.

Pam

> -----Original Message-----
> From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com]On
> Behalf Of dguillett1
> Sent: Monday, October 15, 2012 12:51 PM
> To: ExcelVBA@yahoogroups.com
> Subject: Re: [ExcelVBA] formula not working
>
>
> This should work to check col J for the month and return the sum
> in column L. Be aware that you can NOT use J:J complete columns
> =SUMPRODUCT((MONTH(J2:J22)=7)*L2:L22)
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguillett1@gmail.com
>
> From: Pam
> Sent: Monday, October 15, 2012 12:25 PM
> To: ExcelVBA@yahoogroups.com
> Subject: [ExcelVBA] formula not working
>
>
> I am working with dates, trying to sum up the number of days worked in a
> given month.
> I have a column for start date (col J), end date (col k), and a
> total column
> (col L).
>
> I want to sum the days worked by month in a different column.
>
> I used this formula.
>
> =SUMIF(J:J,MONTH(7),L:L)
>
> The formula's answer was 0.
>
> The correct answer should be 20.
>
> In trying to troubleshoot my formula I did this (The content of J5 is
> 7/23/12):
>
> =IF(J5=MONTH(7),"yes","no") I get NO. The correct answer is YES.
>
> If I type =MONTH(J5) I get an answer of 7. That is the correct answer.
>
> What am I doing wrong?
>
> Pam
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA
> articles! Go here: http://www.mousetrax.com/techtrax to enter the
> ezine, then search the ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>
>
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (26)
Recent Activity:
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------
.

__,_._,___

Tidak ada komentar:

Posting Komentar