Sum of count greater than X formula

[srose]

Hi,
I'm trying to sum the total number of hours foretasted greater than a count of 12 (for weeks worked) and multiple it by an appropriate rate to forecast costs.
For the first 1-12 weeks all staff are on a 12.54 rate per hour, >12 weeks 12.78.
I've attached the file for reference, 55 staff beginning at different weeks throughout the year.
Anyone help with a formula (col AK)?
Thanks!

[martindwilson]

invisible attachment!

[srose]

should be attached now!

[Miraun]

Ok, you confused me...

You can use =COUNTA(F7:AG7) to determine the count of the number of weeks that they have hours allocated.

Are you saying that the first 12 weeks are estimated at 12.54 per hour, and that each week beyond 12 is at 12.78? Or if they are above 12 weeks, all hours become 12.78?

If it's 12.54 for <12, and 12.78 for >12, and not a changing rate, then the equation would be:
=SUM(F7:AG7)*IF(COUNTA(F7:AG7)>12,12.78,12.54)

[srose]

Ok, you confused me...

You can use =COUNTA(F7:AG7) to determine the count of the number of weeks that they have hours allocated.

Are you saying that the first 12 weeks are estimated at 12.54 per hour, and that each week beyond 12 is at 12.78? Or if they are above 12 weeks, all hours become 12.78?

If it's 12.54 for <12, and 12.78 for >12, and not a changing rate, then the equation would be:
=SUM(F7:AG7)*IF(COUNTA(F7:AG7)>12,12.78,12.54)

Thanks, but I needed the first - First 12 weeks at 12.54 and thereafter 12.78.
Any idea's on a formula for this?

[srose]

Thanks, but I needed the first - First 12 weeks at 12.54 and thereafter 12.78.
Any idea's on a formula for this?

Anyone help on this, working on a deadline!

[martindwilson]

=if(c7-12>0,(c7-12)*12.78,0)+if(c7-12>0,12*12.54,0)+if(c7<=12,c7*12.54,0)