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!

 

[Oeldere]

show us a small part of the file.

 

[MKershner]

[/IMG]

Does this help?

 

[Oeldere]

not for me, can't copy it, to work with.

It also be good, to add the expected result in your example.

 

[Jonmo1]

Perhaps

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

 

[MKershner]

Thank you! I was just playing with that formula as you responded. I had:
=SUM(IF(C6=$CK$4,SUM(F6:CI6),0))

Is there anything I can put in cell CK4 (some sort of wildcard) that would make the formula return a value no matter what was in column C? There are blanks. I want only the sum of the rows that have a value in C.

 

[Jonmo1]

Perhaps

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

 

[MKershner]

I am trying to find a way to use that reference cell to total by item but if I leave it blank then total all items with a value in item column. This is what I came up with:
=IF(C6=$CK$4,SUM(F6:CI6),IF($CK$4=""*AND(C6<>""),SUM(F6:CI6),0))

If there is a value in the reference cell the formula works, if I leave it blank it doesn't work. Any suggestions?

 

[Jonmo1]

It's hard to understand what you're trying to do.
A more clear description (in words, not with formula that doesn't work) of what you want would help...

Perhaps you want

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

 

[MKershner]

In that reference cell I want to be able to type in one of the items (ie. GC, F, L) but if I leave it blank I want the formula to capture them all. There are blank items throughout the sheet. I don't need to capture the value of the blank items.

Does that make more sense?

And thank you so much, you have been incredibly helpful!