I'm trying to figure out a sumif formula that uses 2 criteria in 1 column.
For example, lets say I have 2 columns, A and B.
A B
p 2
j 35
m 20
c 40
t 8
j 5
m 1
q 10
I want a formula that will add all the numbers in Column B that are one row underneath m, every time j appears above m in Column A. So in this simple example it would just be 10+40=50.
Hope I explained that well enough. Any ideas?
For example, lets say I have 2 columns, A and B.
A B
p 2
j 35
m 20
c 40
t 8
j 5
m 1
q 10
I want a formula that will add all the numbers in Column B that are one row underneath m, every time j appears above m in Column A. So in this simple example it would just be 10+40=50.
Hope I explained that well enough. Any ideas?