S

#### Sam via OfficeKB.com

I wish to sum the count of a single TEXT criteria that is located in several

(5) non-adjacent columns - hundreds of rows. Also, should I choose to apply

filters: I require the Formula to show the summed count of ONLY Visible

Filtered cells. How can this best be achieved with minimum calculation /

processing overhead?

I located this Formula on

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

=SUMPRODUCT(--(SUBTOTAL(3,OFFSET(INDEX($A$1:$A$100,1,1),ROW($A$1:$A$100)-ROW

(INDEX($A$1:$A$100,1,1)),0))=1),--($B$1:$B$100="North"),$A$1:$A$10)

However, I am not sure if it is feasible to reference my 5 non-adjacent

columns based on the above Formula, perhaps a more suitable solution exists?

Thanks

Sam