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:

Sumifs example
LVL 9
Anthony MellorChartered AccountantAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
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

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

regards, barry
0
 
Saqib Husain, SyedEngineerCommented:
enter this in C6 and then copy it to any row
=sumif(A:A,A6,B:B)
0
 
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.
0
 
Saqib Husain, SyedEngineerCommented:
Can you upload a small sample. I am not good at setting up tables.
0
 
Anthony MellorChartered AccountantAuthor Commented:
brill. :-)   where do you learn that stuff?
0
All Courses

From novice to tech pro — start learning today.