Thread
:
Count Based upon Multiple Conditions
View Single Post
#
5
Max
Posts: n/a
"Biff" wrote
=SUMPRODUCT((B2:B7="X")*(C2:C7+D2:D7+E2:E71))
That's much neater, Biff !
Cheers
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
Reply With Quote