EitanOrgil
New Member
- Joined
- Jan 8, 2014
- Messages
- 18
- Office Version
- 365
- Platform
- Windows
Hi All,
I have a table of 11 columns and 864 rows.
I wont to sum up column F (has only numbers) if:
last 6 characters in column c (they are numbers) match the number in column K
and
column G is exact text, say, "ABCDE"
so if in raw 1, column c has "texttexttext123456" and in column K I have 123456, and column G has the exact text "ABCDE", add number in column F to sum
Column C may have the same text more then once, same with column K
I tried with: =sumifs(F:F,C:C,RIGHT(C:C,6)=K:K)
I get SPILL error, spill range too big.
will appreciate any help
Eitan
I have a table of 11 columns and 864 rows.
I wont to sum up column F (has only numbers) if:
last 6 characters in column c (they are numbers) match the number in column K
and
column G is exact text, say, "ABCDE"
so if in raw 1, column c has "texttexttext123456" and in column K I have 123456, and column G has the exact text "ABCDE", add number in column F to sum
Column C may have the same text more then once, same with column K
I tried with: =sumifs(F:F,C:C,RIGHT(C:C,6)=K:K)
I get SPILL error, spill range too big.
will appreciate any help
Eitan