carabale
Board Regular
- Joined
- Apr 29, 2004
- Messages
- 133
I have a table like the one below, which I update manually and I am trying to automate.
MONTH VALID TOTIM %ID READY
Oct-14 8 10 80%
Nov-14 3 9 33%
Dec-14 7 15 47%
Jan-15 5 16 31%
Feb-15 2 4 50%
On Sheet1, I want to count all "Y" for the month of October and count all records with a date in October so I can calculate the percentage.
I have this formula under VALID
{=SUMPRODUCT(--('Sheet1'!$U2:$U600 = “Y”)*(MONTH('Sheet1'!$K2:$K600)=10))}
And this one under TOTIM
=SUMPRODUCT(--('Sheet1'!$U2:$U600)*(MONTH('Sheet1'!$K2:$K600)=10))
But I only get #NAME? Needless to say, I do not know what I am doing. I pretty much search the this and other sites and kind a put things together.
Hopefully you guys show the the right direction.
PS: the data in worksheet Sheet1 and the table is in worksheet STATS
As always, thanks in advance.
MONTH VALID TOTIM %ID READY
Oct-14 8 10 80%
Nov-14 3 9 33%
Dec-14 7 15 47%
Jan-15 5 16 31%
Feb-15 2 4 50%
On Sheet1, I want to count all "Y" for the month of October and count all records with a date in October so I can calculate the percentage.
I have this formula under VALID
{=SUMPRODUCT(--('Sheet1'!$U2:$U600 = “Y”)*(MONTH('Sheet1'!$K2:$K600)=10))}
And this one under TOTIM
=SUMPRODUCT(--('Sheet1'!$U2:$U600)*(MONTH('Sheet1'!$K2:$K600)=10))
But I only get #NAME? Needless to say, I do not know what I am doing. I pretty much search the this and other sites and kind a put things together.
Hopefully you guys show the the right direction.
PS: the data in worksheet Sheet1 and the table is in worksheet STATS
As always, thanks in advance.