# I need this to use current row cell as criterion =SUMIF(Table1[AA],"A*",Table1[BB])

I have this from previous question

=SUMIF(Table1[AA],"A*",Table1[BB])

The A* adds everything beginning with an A

I am entering a sumif formula in column C

I need to add anything in column B where the column A entry matches the current entry row of column C.

Without using  a Table, this looks like:

LVL 9
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

EngineerCommented:
enter this in C6 and then copy it to any row
=sumif(A:A,A6,B:B)
0
Chartered AccountantAuthor Commented:
that improves the speed of the example image I have given, but doesn't work in the scenario of my question.
0
EngineerCommented:
Can you upload a small sample. I am not good at setting up tables.
0
Commented:
If you click on the cells the formula should be constructed for you - try this version in Excel 2007

=SUMIF(Table1[AA],Table1[[#This Row],[AA]],Table1[BB])

.......or this should work in Excel 2010 or later

=SUMIF(Table1[AA],Table1[@AA],Table1[BB])

regards, barry
0

Experts Exchange Solution brought to you by