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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
=SUMPRODUCT(((B83:BF83)="A")*((B87:BF87)="BOOT")*(B115:BF115)*1)
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!
Posts
45
Registration date
Sunday February 7, 2010
Status
Member
Last seen
April 15, 2012

Looked but can't find any spaces!
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!
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"?
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
760
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
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!