Sumif problem
 

=SUMIF($C:$C,"cs",F:F)+SUMIF('Fabrications
hours'!$C129:$C172,"cs",'Fabrications hours'!F129:F172)

this is my formula what i need to do is divide the result of this by 0.9 and
then divided that by 39

how do i change the formula to do this?

THANKS IN ADVANCE

Sumif problem
 

=(SUMIF($C:$C,"cs",F:F)+
SUMIF('Fabrications hours'!$C129:$C172,"cs",'Fabrications
hours'!F129:F172))/0.9/39

If this post helps click Yes
---------------
Jacob Skaria


"Suddes" wrote:

=SUMIF($C:$C,"cs",F:F)+SUMIF('Fabrications
hours'!$C129:$C172,"cs",'Fabrications hours'!F129:F172)

this is my formula what i need to do is divide the result of this by 0.9 and
then divided that by 39

how do i change the formula to do this?

THANKS IN ADVANCE

Sumif problem
 

Hi,

=(SUMIF($C:$C,"cs",F:F)+SUMIF('Fabrications
Hours'!$C129:$C172,"cs",'Fabrications Hours'!F129:F172)/0.9)/39

Mike

"Suddes" wrote:

=SUMIF($C:$C,"cs",F:F)+SUMIF('Fabrications
hours'!$C129:$C172,"cs",'Fabrications hours'!F129:F172)

this is my formula what i need to do is divide the result of this by 0.9 and
then divided that by 39

how do i change the formula to do this?

THANKS IN ADVANCE

Sumif problem
 

or you could divide it by 43.333

"Jacob Skaria" wrote:

=(SUMIF($C:$C,"cs",F:F)+
SUMIF('Fabrications hours'!$C129:$C172,"cs",'Fabrications
hours'!F129:F172))/0.9/39

If this post helps click Yes
---------------
Jacob Skaria


"Suddes" wrote:

=SUMIF($C:$C,"cs",F:F)+SUMIF('Fabrications
hours'!$C129:$C172,"cs",'Fabrications hours'!F129:F172)

this is my formula what i need to do is divide the result of this by 0.9 and
then divided that by 39

how do i change the formula to do this?

THANKS IN ADVANCE

Sumif problem
 

Well, yes you *could*, but it would give you a different answer. :-(
Perhaps you intended to say that you could divide by 35.1?
--
David Biddulph

"Atishoo" wrote in message
...
or you could divide it by 43.333

"Jacob Skaria" wrote:

=(SUMIF($C:$C,"cs",F:F)+
SUMIF('Fabrications hours'!$C129:$C172,"cs",'Fabrications
hours'!F129:F172))/0.9/39

If this post helps click Yes
---------------
Jacob Skaria


"Suddes" wrote:

=SUMIF($C:$C,"cs",F:F)+SUMIF('Fabrications
hours'!$C129:$C172,"cs",'Fabrications hours'!F129:F172)

this is my formula what i need to do is divide the result of this by
0.9 and
then divided that by 39

how do i change the formula to do this?

THANKS IN ADVANCE

Sumif problem
 

Thanks..0.9 and 39 could be cell references and hence this way..


"Atishoo" wrote:

or you could divide it by 43.333

"Jacob Skaria" wrote:

=(SUMIF($C:$C,"cs",F:F)+
SUMIF('Fabrications hours'!$C129:$C172,"cs",'Fabrications
hours'!F129:F172))/0.9/39

If this post helps click Yes
---------------
Jacob Skaria


"Suddes" wrote:

=SUMIF($C:$C,"cs",F:F)+SUMIF('Fabrications
hours'!$C129:$C172,"cs",'Fabrications hours'!F129:F172)

this is my formula what i need to do is divide the result of this by 0.9 and
then divided that by 39

how do i change the formula to do this?

THANKS IN ADVANCE

Sumif problem
 

Many thanks Jacob & Mikde i always get lost off nowing where to place the '(
)' i wish there were an easy way to know.
Thanks again

"Mike H" wrote:

Hi,

=(SUMIF($C:$C,"cs",F:F)+SUMIF('Fabrications
Hours'!$C129:$C172,"cs",'Fabrications Hours'!F129:F172)/0.9)/39

Mike

"Suddes" wrote:

=SUMIF($C:$C,"cs",F:F)+SUMIF('Fabrications
hours'!$C129:$C172,"cs",'Fabrications hours'!F129:F172)

this is my formula what i need to do is divide the result of this by 0.9 and
then divided that by 39

how do i change the formula to do this?

THANKS IN ADVANCE