Solved

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

Posted on 2013-06-03
499 Views
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:

0
Question by:anthonymellorfca
• 2
• 2

LVL 43

Expert Comment

ID: 39217009
enter this in C6 and then copy it to any row
=sumif(A:A,A6,B:B)
0

LVL 9

Author Comment

ID: 39217057
that improves the speed of the example image I have given, but doesn't work in the scenario of my question.
0

LVL 43

Expert Comment

ID: 39217068
Can you upload a small sample. I am not good at setting up tables.
0

LVL 50

Accepted Solution

barry houdini earned 500 total points
ID: 39217114
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

LVL 9

Author Closing Comment

ID: 39217399
brill. :-)   where do you learn that stuff?
0

## Featured Post

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…