RE: [ExcelVBA] formula not working

 

Thank you for your suggestion but when I tried it it gives me an answer of
0.

Maybe I am going about this all wrong.

This is a clip from my sheet.

col I col J col K col L col M
Location On Off # DaysOn # DaysOff
off 07/20/12 0 3
Hansen Kullin 5h 07/23/12 07/29/12 6 0
Hansen Kullin 5h,6h 07/29/12 08/12/12 14 41
Martindale L-C 1,2h 09/22/12 10/01/12 9 19
Baird Heirs 3,4h 10/20/12

Here is what I want to do.
I want to be able to total the days worked by months, in this clip, they
worked in 8 days in July, 12 in August, 8 in Sept, and 1 in Oct.

Does anyone have any suggestions? I am using Excel 2000 version.

Pam

> -----Original Message-----
> From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com]On
> Behalf Of Reinaldo
> Sent: Monday, October 15, 2012 12:57 PM
> To: ExcelVBA@yahoogroups.com
> Subject: RES: [ExcelVBA] formula not working
>
>
> You can try
>
> =SUM(IF(MONTH(J:J)=7;L:L)) and finalize with Ctrl+Alt=Enter (this is a
> matricial formula) you will see ={ SUM(IF(MONTH(J:J)=7;L:L))}
>
>
>
>
> De: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] Em nome de
> Pam
> Enviada em: segunda-feira, 15 de outubro de 2012 14:25
> Para: ExcelVBA@yahoogroups.com
> Assunto: [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.
>
>
> What am I doing wrong?
>
> Pam
>
>

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (27)

Recent Activity:

• New Members 8

Visit Your Group

----------------------------------
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

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___