Sumproduct for mutiple tabs

[djfatboyfats]

I need a formula for looking for a specific word in the same column on all tabs,i know how to do the formula for 1 tab

Please Login or Register  to view this content.

but over muliple tabs i have to repeat it for each tab. Example

Please Login or Register  to view this content.

The must be an easier way.

Thanks

DJ

[EdMac]

SUMPRODUCT(('Feb:April'!A15:A10000=Your value)*etc

Ed

[vane0326]

May we see a sample workbook?

[djfatboyfats]

Still not getting this to work does anyone have any ideas why?

Please Login or Register  to view this content.

[vane0326]

List your worksheets names in cells B2:B4

Select B2

Insert > Name > Define

Name: wks

Refers to:

=TRANSPOSE(Sheet1!$B$2:$B$4)

Click Ok

Then try...

Please Login or Register  to view this content.

If it doesn't work please post a sample workbook.

[EdMac]

Hi,

You have different range sizes 15:1000, 15:10000 - try with both the same.

Ed

[djfatboyfats]

I cannot get this wo work i have attached a sample worksheet for you to see, due to the size i have had to trim it down a bit actully alot i have had top remove all tabs, but hope you get the idea,