VLOOKUP/ SUMIF not sufficient
 

Hi,

For Example...
Data is in Rows 1-800
Data is in Colm A-CD
Data is in sheets : S2, S3, S4
You want to find # of A's, B's, C's, etc...
Results are in S1 (sheet)

Try using:
For one Workbook...
=+COUNTIF('S2'!D3:K11,'S1'!E4)+COUNTIF('S3'!D3:K10 ,'S1'!E4)+COUNTIF('S4'!D3:K10,'S1'!E4)

I realize this is not ideal, but, it will cover multi-sheets and....
books. Just add the additional ones to the end.

For Multi Workbooks...
=+COUNTIF('S2'!A1:H9,'S1'!B2)+COUNTIF('S3'!A1:H8,' S1'!B2)+COUNTIF('S4'!A1:H8,'S1'!B2)+(COUNTIF([Book2]B2S1!$A$1:$G$8,B2))

Hope this helps :)


Morgwen


--
MorgwenPosted from http://www.pcreview.co.uk/ newsgroup access