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

I have this from previous question


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:

Sumifs example
Anthony MellorChartered AccountantAsked:
Who is Participating?
barry houdiniConnect With a Mentor 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


regards, barry
Saqib Husain, SyedEngineerCommented:
enter this in C6 and then copy it to any row
Anthony MellorChartered AccountantAuthor Commented:
that improves the speed of the example image I have given, but doesn't work in the scenario of my question.
Saqib Husain, SyedEngineerCommented:
Can you upload a small sample. I am not good at setting up tables.
Anthony MellorChartered AccountantAuthor Commented:
brill. :-)   where do you learn that stuff?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.