sumproduct through workbook

[MartinL]

Hi

Is it possible to use sumproduct over a workbook?

I have 15 different codes that I want to total the values of in an adjacent column

each worksheet is for a different day (ie 365 worksheets)
each code can appear more than once (but is always in Col H) and rarely on the same row

each sheet contains about 50 rows (if that makes a difference)

will a pivot table handle this?

 

[Andrew Poulsom]

If there is only one criteria, you can try the last example here:

http://www.mcgimpsey.com/excel/threedsumif.html

 

[MartinL]

Thanks andrew

Is there a way of gettin excel to list all the sheet names in a column on a sheet called index

 

[Andrew Poulsom]

One way:

http://www.dailydoseofexcel.com/archives/2005/05/12/non-vba-table-of-contents/

 

[MartinL]

answering my own question i just found this

http://www.meadinkent.co.uk/worksheet-names.htm

 

[T. Valko]

Is there a way of gettin excel to list all the sheet names in a column on a sheet called index

Here's one way:

http://www.mrexcel.com/forum/showthread.php?p=2118912#post2118912

 

[MartinL]

Biff

Thanks a lot,
this has got to be the best community board around, even when I have found a answer to a problem people are willing to add their thoughts and ideas

 

[T. Valko]

Biff

Thanks a lot,
this has got to be the best community board around, even when I have found a answer to a problem people are willing to add their thoughts and ideas

You're welcome. Thanks for the feedback!