Formula Calc Percentage

[lec2012]

Hi I am hoping someone can help me calculate this formula.

Basically i have 3 columns.

Column A = (Total Percentage the person is Trained)e.g 80%
Column B = (has the person been with us less than 30days)e.g N
Column C = (is the person fully trained i.e. is Column A 100%) e.g N

I now need a calculation that will total all the percentage amounts in Column A but only if column B & C say Y

The percentage also needs to be over the amount of employees that are within 30days and fully trained. This cell is C2

I hope i explained this ok, and any help would be greatly appreciated.

 

[anandvarma]

try this

=SUMIFS(A:A,B:B,"y",C:C,"y")

 

[lec2012]

Thank you for your response....

As column is a % (number) it doesn't seem to be working.

It's just coming up with .... #NAME?

 

[anandvarma]

which version of excel you are using

 

[lec2012]

2003

 

[anandvarma]

try this

=SUMPRODUCT(--(B:B="y")*(C:C="y")*A:A)

 

[lec2012]

Hi
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
Sorry I have reconfigured my requirement from looking over the ss again.
<o> </o>
Here goes….I hope this is explained a little better than my previous attempt:
<o> </o>
Example One:<o></o>
<o> </o>
AK 8 = 95% (What percentage trained is the employee?)
AL 8 = No (Has the person been with us less than 30days?)
<o> </o>
Example Two:<o></o>
<o> </o>
AK 9 = 80% (What percentage trained is the employee?)
AL 9 = Yes (Has the person been with us less than 30days?)
<o> </o>
In column AN8 I would want the percentage in AK8 as the person has been with us for more than 30days (Column AN8 should be returned as 95%)
<o> </o>
In column AN9 I would want the percentage to be discounted (or omitted / returned as zero) as the person has been with us less than 30days.