Countif() in Let() Query

[mart_mrexcel]

I am trying to check if any of the "name" result in Let() is TRUE then return TRUE. When I use the COUNTIF() formula inside the Let(), it gives me #VALUE! error.

A	B	C	D	E
1	Group​	Type​	Total​
2	Stationary	Note Book	8	=LET(Group,A2="Computer", LET(Type,B2="Note Book", LET(Total,C2<50, IF(COUNTIFS((Group,Type,Total),TRUE)>0,TRUE,FALSE))))
3

 

[Cubist]

Usually, you don't need more than one LET. Secondly, COUNTIFS takes in a criteria range and criteria alternately so your syntax isn't quite right. Try:

=LET(Group,A2="Computer",Type,B2="Note Book",Total,C2<50,OR(Group,Type,Total))

I'm not sure if this is a smaller question of a bigger question, but since there's no repeated calculation, you don't need LET.

=OR(A2="Computer",B2="Note Book",C2<50)

 

[mart_mrexcel]

Usually, you don't need more than one LET. Secondly, COUNTIFS takes in a criteria range and criteria alternately so your syntax isn't quite right. Try:

=LET(Group,A2="Computer",Type,B2="Note Book",Total,C2<50,OR(Group,Type,Total))

I'm not sure if this is a smaller question of a bigger question, but since there's no repeated calculation, you don't need LET.

=OR(A2="Computer",B2="Note Book",C2<50)

Actually, It's a bigger question. Thank you so much for assistance, this works perfectly. Have a great day ahead