Brent
asked on
Adjusting nested Array Forumula - Date Format
With help, I created this worksheet where the Array Formula collects hours from D & E column and it sums for each month in G10:I17 (D column) & G26:I33 (E Column).
{=SUM(IF(TEXT($C$4:$C$220, "mmm")=G10 ,$D$4:$D$2 20))}
It works perfect except I just noticed that is is summing Dec 2010 into Dec 2011 totals into I17. It makes sense because it is looking for DEC only, not looking at the year. I need the Dec 2010 totals into a new set labeled in G8 with the total in G9. I tried to change the formatt of the formula to also look at the year, but I was not successful.
Thanks for any help.
Brent Expert-sumiftext-questions.xls
{=SUM(IF(TEXT($C$4:$C$220,
It works perfect except I just noticed that is is summing Dec 2010 into Dec 2011 totals into I17. It makes sense because it is looking for DEC only, not looking at the year. I need the Dec 2010 totals into a new set labeled in G8 with the total in G9. I tried to change the formatt of the formula to also look at the year, but I was not successful.
Thanks for any help.
Brent Expert-sumiftext-questions.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sorry, Brent ....:)
ASKER
sorry, password is 678. Let me look and try this. thanks
ASKER
Yes, that did the trick. I am will go back and read up on sumproduct, so I understand the )+0
portion of the furmula and also how it uses the text and format to sum the numbers.
Thanks
Brent Expert-sumiftext-questions.xls
portion of the furmula and also how it uses the text and format to sum the numbers.
Thanks
Brent Expert-sumiftext-questions.xls
ASKER
Thank you.