Summing data from multiple sheets and dropdown lists

I haven't expressed my problem very well.

I am making a downtime tracking sheet (based on someone elses template)

Downtime is entered according to three criteria. Process, Machine, Fault.
I would like to hvae have a seperate sheet for each month, but I don't know how to change the Sumif formulas to gather data from each monthly sheet and and give a total next to the Process, Machine and Fault lists.

If someone good help me out I would be most appreciative. But please, use small words, I'm very new to this.

Thanks
2011 Downtime Tracking.xlsm

Hi

I don't think you can do a sumif across multiple sheets. I've seen some but they do get complicated. Here's one

As you seem to have no issues using macros, maybe you could build a UDF to do things...

rylo

Hi Rylo, thanks for your input. I had a look and I think I'll stick with the first piece of advice given in that thread. Keep it simple. I won't make seperate sheets for each month.

If you (or anyone else that drops in) could help me on something else in that same workbook though, it would be great.

There is a sumif function that totals the amount of downtime recorded in sheet 1 (colum F) against a machine (coloumn D) and records it against the machine in the Machine Sheet. I would like to be able to record the downtime next to the machine but break it down further with data from column E

So in my Machine sheet I could have a column for Choke downtime, and another column for Fire Downtime etc next to the machine.

Sorry if I'm not explaining this well. I don't know the correct terminology for this stuff.

p.s. I have no idea about macros, the person that made the templat stuck those in there :-)

thanks again, any input welcome

Hi

you could use SUMPRODUCT to bring back the result of multiple selection criteria from a single data source sheet. There are pleny of examples on this site.

If you want something specific for your situation, then update your example file to show more data, and how / where you want the output to be displayed.

Also, with the exising sumif function, you don't need to put the string into the formula. If you look at the formula in Machine!B2, you could replace the "1. Trash Bin Auger" with B2 and then you can just copy the formula down without having to modify each one.

rylo

. If you look at the formula in Machine!B2, you could replace the "1. Trash Bin Auger" with B2 and then you can just copy the formula down without having to modify each one.


d'oh
So obvious and simple, told you I was hopeless at this stuff. Thankyou

I'll have another go at the part shortly