sum of all "L" in cells

**NBVC** · 04-06-2011, 09:07 AM

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

**ivan.985** · 04-06-2011, 04:15 PM

this is almoust Ok, but what i to do with second and sixth sheet; where J25 in second and K27 in sixth sheet. There is show L/R or R/R or something like that, in one cell! How there to calculate how much L and how much r show! I don't know, do you understand that in row "KOM" is number of L and R and half of that number is L and half R, or if in K27 Show R/R then number in row "Kom" is number of R for that sheet! If that can with function that will be good!!!

**NBVC** · 04-06-2011, 04:34 PM

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.

**ivan.985** · 04-06-2011, 05:26 PM

Yes, YES, YES, you are king of excell

**ivan.985** · 04-06-2011, 06:14 PM

hey please just one more quetion. You (plural) looks like realy smart guy's. And looks like all can be done with functions! Here is one more attachment. It's just like first one, but here is one more sheet! In this sheet need to, Copy names of others sheet in row "sheet name"; in row "dimension" copy cell bottom of picture in left cell, and right cell from picture in right cell of "dimension"! In cell No, copy cell like in first sheet cell B23. But only when choose options in sheets "Obradi"!
Now is problem if I choose first "Obradi" in last cell - all information from that cell copy in first column of last sheet, and next choose "Obradi" in first cell - all informations copy to second column, and just next to next copying in next column! I hope that you understand what I mean!