sum of all "L" in cells

I'll give this 1 try:

I think the easiest way would be to assign one cell in each sheet (the same cell) and enter a formula in each that sums those values in each sheet.

Then you can add a formula in the summary sheet that sums that cell from each sheet.

For example, say you pick cell T2 in each each to contain a summing formula, then you can have something like:

=IF(D32="Obradi";SUMIF(J21:J29;"L";L21:L29);0)

and in T3


=IF(D32="Obradi";SUMIF(J21:J29;"R";L21:L29);0)

so if D32 is not Obradi, you will get 0.

do this in each sheet, and change L's to M's where necessary to get same result.

Then in the last sheet you would sum that cell from each sheet with formula like this:

=SUM('K1-OK:Vrata 1K'!T2) for "L" count

and


=SUM('K1-OK:Vrata 1K'!T3) for "R" count

You may need to translate the functions to your language