Previous Topic Next Topic

Add when multiple criteria is met in rows

[Solved/Closed]
Report
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
 -
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
 -
Hello,

I'm trying to add numebrs when multiple criteria is met! I want to add numbers in B115:BF115, but only the ones that have an "A" in row B83:BF83 and "Boot" in row B87:BF87.

I tried =SUMPRODUCT(--(B83:BF83="A")*(B87:BF87),B115:BF115)) and a couple of other but it does not seem to be counting!

Any suggestions if it can done this way with the rows?

Thanks

2 replies

Answer 1 / 2
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
=SUMPRODUCT(((B83:BF83)="A")*((B87:BF87)="BOOT")*(B115:BF115)*1)
Answer 2 / 2
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
Hi rivisa 1, tried it but it does not add up at all!
View all 13 comments
Report
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
Looked but can't find any spaces!
Report
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
Thanks rivisa got the problem, made that row TEXT, saw what you mean by space!
Report
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
How would you count time below 30minutes with criteria "A" and "SMART"?
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768
Sorry did not understand what you meant by counting time
are you looking for some thing
that in addition to above 2 criteria, only add if the Total Cycle Time(gate to Gate) is less than 30 minute
Report
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012
TX rivisa1 i've found what i was looking for!
Ask a question