Sumif across a row of data

[Pjam]

Is there any way to use the sum ifhorizontally instead of vertically. Or does this need to be done a different way?

 

[gsbelbin]

You can use it horizontally. I set up two rows of cells; the top one with random letters in it, some of which were q. Then below that I put random numbers. In another cell I put

=SUMIF(F1:F9,"=q",F2:M2)

It gives the correct answer.

Is this what you mean?

 

[AlphaFrog]

<br /><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">2</td><td style="text-align: right;background-color: #FFFF00;;">3</td><td style="text-align: right;background-color: #FFFF00;;">4</td><td style="text-align: right;background-color: #FFFF00;;">5</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">10</td><td style="text-align: right;;">10</td><td style="text-align: right;background-color: #FFFF99;;">10</td><td style="text-align: right;background-color: #FFFF99;;">10</td><td style="text-align: right;background-color: #FFFF99;;">10</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;background-color: #FFFF99;;">30</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><br /><br /><table cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A4</th><td style="text-align:left">=SUMIF(<font color="Blue">A1:E1, ">=3",A2:E2</font>)</td></tr></tbody></table></td></tr></table><br />

 

[Pjam]

No thats still vertical

I mean, so C1 is column 1 , i need to sum sumiif all the values in row A so the answer would be 3 and for B it would be 7.

C1 C2 C3
A 1 2
B 3 4

 

[mikerickson]

Perhaps
=SUM(INDEX(A:C, MATCH("A", A:A, 0),))

 

[dgehlod]

i have condition in R2C1 ( A2 ) and Value in B2 Same in the another cloumn

we have only two Condition "DC" And "CC"
Condition A2 C2 E2
Value B2 D2 F2

Want to apply sumif based on condition is there any solution

 

[Aladin Akyurek]

i have condition in R2C1 ( A2 ) and Value in B2 Same in the another cloumn

we have only two Condition "DC" And "CC"
Condition A2 C2 E2
Value B2 D2 F2

Want to apply sumif based on condition is there any solution

Try to post some actual data, actual conditions which must apply, and the outcome for the posted data.