Thread
:
Count Based upon Multiple Conditions
View Single Post
#
4
Max
Posts: n/a
Put in F2: =IF(AND(TRIM(B2)="X",SUM(C2:E2)1),"Y","")
Copy down to E7
Typo, sorry .. E7 should read F7
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Reply With Quote