In need of a formula. Then maybe i can turn write it into a vba code.

[zone709]

Hi I need a formula for my sheet any help?

If in Column "C" it says Engineer in any number line to add all hours in total SUM from column E,I,M,Q,U. ?

This shouldn't be hard, but I don't know how to do it

 

[MUKESHY12390]

I think you need to be more specific, I mean you want sum of same ROW or entire column if "Engineer" value found in column "C".

 

[zone709]

Sorry if "Engineer" value found in column "C". then add the numbers I have in COLS E,I,M,Q,U. I have hours in there like example 8.00 8.00 6.00

 

[Laurenplus]

Try this code:

 =sum(if(C2:C10="Engineer", E2:U10))

Assume the last row is 10. You need to change 10 to the last row on your wooksheet.
Formula Array:
Produce enclosing { } by entering
formula with CTRL+SHIFT+ENTER!

Sorry if "Engineer" value found in column "C". then add the numbers I have in COLS E,I,M,Q,U. I have hours in there like example 8.00 8.00 6.00

 

[MUKESHY12390]

it seems Laurenplus has given your answer. but my question was that you need sum of that row(E,I,M,Q,U) in which "Engineer value" found.

for eg.

lets assume "Engineer" word found in C10 then your target output would be sum of ((E10,I10,M10,Q10,U10).

 

[zone709]

it seems Laurenplus has given your answer. but my question was that you need sum of that row(E,I,M,Q,U) in which "Engineer value" found.

for eg.

lets assume "Engineer" word found in C10 then your target output would be sum of ((E10,I10,M10,Q10,U10).

Yes maybe i explained it wrong in a way, but thats it. Thanks guys for the help

 

[MUKESHY12390]

Glad you have found solution

 

[zone709]

Hi Im putting this on Line 456 Column C. I change the range to formula above but still get value 0.

My range for where Engineer is is from C4 to C 455 right. I have the formula below on C456.

Example Engineer on my sheet for testing is on line 447 col "C" and his hours are in E447,I447,M447,Q447,U447


I GET value zero.

I change formula to this

=sum(if(C4:C455="Engineer", E4:U455))

Not sure this looks right. I need the range to find Engineer in COl C and look for total hours in the letter columns E,I,M,Q,U.

Thanks again for the help in advance.

 

[zone709]

This is still giving me no value

=sum(if(C2:C10="Engineer", E2:U10))

My range on this now is 4 to 295 on both C and E,I,M,Q,U for where my hours are

 

[Scott Huish]

That formula will work if there are no values in the columns you are skipping. If that is the case, did you confirm it with CTRL-SHIFT-ENTER rather than just Enter?

<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /><col style="width:64px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >C</td><td >D</td><td >E</td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td><td >P</td><td >Q</td><td >R</td><td >S</td><td >T</td><td >U</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="text-align:right; ">50</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td >Engineer</td><td > </td><td style="text-align:right; ">8</td><td > </td><td > </td><td > </td><td style="text-align:right; ">8</td><td > </td><td > </td><td > </td><td style="text-align:right; ">8</td><td > </td><td > </td><td > </td><td style="text-align:right; ">8</td><td > </td><td > </td><td > </td><td style="text-align:right; ">5</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td><td > </td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td >Engineer</td><td > </td><td style="text-align:right; ">5</td><td > </td><td > </td><td > </td><td style="text-align:right; ">1</td><td > </td><td > </td><td > </td><td style="text-align:right; ">1</td><td > </td><td > </td><td > </td><td style="text-align:right; ">2</td><td > </td><td > </td><td > </td><td style="text-align:right; ">4</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >C1</td><td >{=SUM(IF<span style=' color:008000; '>(C4:C455="Engineer",E4:U455)</span>)}</td></tr></table></td></tr><tr><td ><span style=' font-family:Arial,Arial; font-size:9pt; font-weight:bold;'>Formula Array:</span><span style=' font-family:Arial,Arial; font-size:9pt;'><br />Produce enclosing </span><span style=' font-family:Arial,Arial; font-size:9pt; font-weight:bold;'>{ }</span><span style=' font-family:Arial,Arial; font-size:9pt;'> by entering<br />formula with CTRL+SHIFT+ENTER!</span></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span>