sum of all "L" in cells

I'm from serbia and my english is very bad, but i can't find solution of my problem on my language!

I need to sum all letter L and all letters R in all sheets in sheet "Poručivanje okova"
When i in first sheet "K1-OK", in cell D32 choose option "Obradi" then in last sheet in cell C29 and cell D29 calculate how much letters L and R in anothers sheets in cells where writes "Donji falcni nosač na krilu" and need result need to be like 10L and 10R!

How can I put button in excell sheet to change option like in cell d32 in first sheet, when i click on button to be like i choose options "Obradi"!

Thanks a lot!

This looks more like a formula problem.
Can you put some real values your sheets?
This might help with the translation problem, then we might be able to trace the data better.

I can't find values in M25;M27 anywhere!

Also try to get rid of merged cells, they will just make life hard for no good reason.

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

How about you use formula in T2 of each sheet:

=IF(D32="Obradi";SUM(SUMIF(J21:J29;{"L";"L/L"};L21:L29))+SUM(SUMIF(J21:J29;{"L/R";"R/L"};L21:L29))/2;0)

and, in T3

=IF(D32="Obradi";SUM(SUMIF(J21:J29;{"R";"R/R"};L21:L29))+SUM(SUMIF(J21:J29;{"L/R";"R/L"};L21:L29))/2;0)

change or add for K where necessary.

Repost the sheet with information manually filled in to show what you are trying to do. Also mention exactly where the information would come from for each column.

Have a look at the attached.

First somewhere on the side, list all the sheets involved. I listed them in Q5:Q11, for example.

Then in R5 I entered formula:

=IF(INDIRECT("'"&$Q5&"'!D32")="Obradi",INDIRECT("'"&$Q5&"'!A21"),"")

and copied down. This looks at the sheet which is named in Q5 and sees if Obradi is in D32, and if it is it returns the "green" dimension otherwise it remains blank.

Note: You may have to change the some references because some of your sheets have the "yellow", "green" and/or "red" cells in different locations.

You can copy that formula down.

The formulas in the next 2 columns are similar, but they get back the "yellow" and "red" data:

Now in the main table, to get the Sheetnames that have dimensional info, into columns B:D, you have to unmerge the column, so I recommend you delete C and D and just make B wider and center the text....

Then in B17 you enter:

=IFERROR(INDEX(O$5:O$11,SMALL(IF(ISNUMBER(P$5:P$11),ROW(O$5:O$11)-ROW(O$5)+1),ROWS($A$1:$A1))),"")

This is an array formula and you have to hold the CTRL and SHIFT keys down before pressing ENTER so that the { } brackets appear, then you can copy the formula down.

To get the "green" info, it is a similar array entered formula:

=IFERROR(INDEX(R$5:R$11,SMALL(IF(ISNUMBER(R$5:R$11),ROW(R$5:R$11)-ROW(R$5)+1),ROWS($A$1:$A1))),"")

Then "yellow" and "red" columns would be similar.

I may have read it, but I certainly didn't understand it.

If you mean, does the line disappear from the last sheet, if anyone changes D32 from Obradi to anything else, then yes, it will disappear from the list in the last sheet.

If you want the line to remain even if the user removes Obradi from a D32 cell, then no, it can't be done with normal Excel functions. You would need to rework all the above work using VBA macros....

Please be more specific. Which exact formula in which cell. Also what should the real result be?

As I mentioned earlier, you do not have the "green", "yellow" and "red" cells consistently placed in same cells on all the sheets, so you will need to change some of the formulas in the Otpremnica sheet in P5:R11 so that the formulas point to the right cells.

See attached

My last attachment showed you that you had to change the formulas.

I don't understand what you mean when you say... "I modify in them but nothing!"

Please show me! Post the workbook!

In that sheet, your Obradi cell is in D33 not D32 like all other sheets.

Move it to D32 for consistency!

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save