Sumif a row based on one cell in that row

[MKershner]

I have a worksheet with about 300 rows and 100 columns. I need to sum the rows based on one cell in the beginning of the row that contains text. I want to be able to type the text in a cell at top of the last column and use that as the reference to sum.

Here is the formula that is not working (returning zeros):
=SUMIF(C6,"="&$CK$4,F6:CI6)

Any ideas to make this work?!

Thanks!

 

[Jonmo1]

In that reference cell

Which one? C6 or CK4 ?

 

[MKershner]

Sorry, CK4.

 

[Jonmo1]

So if $CK$4 is Blank, then SUM(F6:CI6)

If $CK$4 is NOT blank, then
If C6=$CK$4, then SUM(F6:CI6)

Otherwise do nothing

Right?

=IF(OR(C6=$CK$4, $CK$4=""),SUM(F6:CI6),"")

 

[MKershner]

That is still picking up the blanks in column C.

If C6 is blank then I do not need the sum of F6:CI6.

If $CK$4 is blank then only sum F6:CI6 if C6 is not blank. If there is a value in $CK$4 then only sum F6:CI6 if that value is in C6.

I feel like this may be a losing battle with excel for me!

 

[Jonmo1]

So
if CK4 is Blank AND C6 is NOT blank, then SUM(F6:CI6)
if CK4 is Blank AND C6 is Blank, then do nothing
If CK4 is NOT Blank AND C6=CK4, then SUM(F6:CI6)
If CK4 is NOT Blank AND C6<>CK4, then do nothing

Is that right?

 

[MKershner]

Yes!

 

[Jonmo1]

Try

=IF($CK$4="",IF(C6<>"",SUM(F6:CI6),""),IF(C6=$CK$4,SUM(F6:CI6),""))

 

[MKershner]

That works!
I can't thank you enough!

 

[Jonmo1]

You're welcome.