Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF problem | Excel Discussion (Misc queries) | |||
Sumif problem | Excel Worksheet Functions | |||
=SUMIF Problem | Excel Worksheet Functions | |||
SUMIF Problem | Excel Worksheet Functions | |||
SUMIF problem | Excel Worksheet Functions |