SUMIF INDIRECT WITH COLUMN NAMES please help!!! urgent

[screaming]

Hi all

I am having problems with this formula:

=sumif(indirect("Table1[Current],1,Table1["&$A31&"]"))

the text within the square brackets are column names.
$A31 refers to a cell that has the column name.

I get the error message, you have entered too few arguments.

I can't see anything wrong with the brackets. When I test the string in a concatenate formula it reads correct.

Many thanks

 

[Joyner]

Hello and welcome to the board:
Is A31 your criteria? If so it seems like you should just have:
=sumif(Table1[Current],$A31)

And if you have a separate sum range you need another argument

 

[screaming]

Hello and welcome to the board:
Is A31 your criteria? If so it seems like you should just have:
=sumif(Table1[Current],$A31)

And if you have a separate sum range you need another argument

The sumif formula is:

=sumif(Table1[Current],1,Table1[Basic Salary])
[Current] is the range
1 is the criteria
[Basic salary] is the sum range

I just need indirect to read this.

 

[screaming]

[Basic]

salary is replaced by$A31

 

[screaming]

Re: SUMIF INDIRECT WITH COLUMN NAMES please help!!! SOLVED

Thank you

I solved this with =sumif(Table1[Current],1,indirect("Table1["&$A31&"]"))

Where sumif is used it looks like indirect needs to appear in separate expressions.

 

[Joyner]

I think you need this:

=SUMIF(Table1[Current],A24,INDIRECT("Table1["&A31&"]"))

 

[Joyner]

I see you got it, great...