help needed debugging selection in "Cash register"

[speedone]

I'll try to keep it short: I've been busy working on a cash register. I'm a newby so it's probably full of things that I could have done different/better. I'm working on a sheet where I can specify sales by selection of month (Sheetname= ZoekenMaand).

Everything works fine for the months "januari" and "februari" (yes, it's in dutch ) but from "maart" it doesn't seem to work any more. I'm totally out of ideas why it doesn't work...

If anyone would be so kind to take a look at it and find what's wrong with my coding I would be very gratefull

[JBeaucaire]

Just hiding rows won't make an INDEX/MATCH function ignore the hidden values. If you want ONLY the visible "January" to be considered by the INDEX/MATCH function, you will need to change the name(s) slightly on those visible rows.

For instance, the rows you have visible you could change to January1, Februari1,Maart1, etc.

Then in your "MATCH() formula, you use MATCH($C$2&"1",...etc...

[royUK]

The most effective way to record sales is in one tabl with a date column. Then create a PivotTable based on the data - the dates can be grouped by months and quarters.

http://www.excel-it.com/pivot_tables.htm

[speedone]

Thanks you both for your quick reply's! I tried the first solution and it works like a charm. Just renamed the months to "januari_09" and so on and everything works perfect now!

Thanks again