Spreadsheet: 774628d1648573910-count-different-type-of-text-and-give-me-text-and-sum-of-numbers-how-to-count2_no-formulas-mariaoskars-
Sheet: Sheet2

Nr | name | work | cost | nr1 | Sum of sum
3 | Name3 | Vogaskóli | M2125 |  | 393613.1319838057
4 | Name4 | Steinahlíð | D156 |  | 407770.1119838057 |  |  |  |  |  |  |  |  |  |  |  |  |  | Select the Filter/Option button in cell [NAME] (column header for the Nr field).
6 | Name6 | Heiðarborg | D126 |  | 434250.3819838057 |  |  |  |  |  |  |  |  |  |  |  |  |  | Select Value Filters from the drop down.
8 | Name8 | Breiðholtsskóli | M2140 |  | 393613.1319838057 |  |  |  |  |  |  |  |  |  |  |  |  |  | Select Does Not Equal from that list.
9 | Name9 | Breiðholtsskóli | M2140 |  | 393613.1319838057 |  |  |  |  |  |  |  |  |  |  |  |  |  | In the Value Filter dialog box type the number 0 (zero) into the third window.
14 | Name14 | [NAME] | D108 |  | 513691.1919838056 |  |  |  |  |  |  |  |  |  |  |  |  |  | Select OK.
21 | Name21 | [NAME] | M2301 |  | 423158.1319838057 |  |  |  |  |  |  |  |  |  |  |  |  |  | Let us know if you have any questions.
36 | Name36 | Austurbæjarskóli | M2105 |  | 262777.9923886639
37 | Name37 | Austurbæjarskóli | M2105 |  | 262777.9923886639
38 | Name38 | Austurbæjarskóli | M2105 |  | 262777.9923886639
44 | Name44 | Grandaborg | D119 |  | 434250.3819838057
48 | Name48 | Engjaskóli | M2162 |  | 404805.1319838057
49 | Name49 | [NAME] | D154 |  | 473970.2719838057
50 | Name50 | Engjaskóli | M2162 |  | 404805.1319838057
54 | Name54 | Fífuborg | D114 |  | 513691.1919838056
56 | Name56 | Melaskóli | M2103 |  | 375397.1319838057
57 | Name57 | Hagaskóli | M2104 |  | 375397.1319838057
58 | Name58 | Breiðagerðisskóli | M2122 |  | 393613.1319838057
59 | Name59 | Breiðagerðisskóli | M2122 |  | 393613.1319838057
63 | Name63 | Sunnuás | D1104 |  | 434250.3819838057
68 | [NAME] | Vogaskóli | M2125 |  | 393613.1319838057
70 | Name70 | Vogaskóli | M2125 |  | 393613.1319838057
72 | Name72 | Vogaskóli | M2125 |  | 393613.1319838057
74 | Name74 | Birta | M2120 | M656 | 393613.1319838057
75 | Name75 | Birta | M2120 | M656 | 393613.1319838057
76 | Name76 | Birta | M2120 | M656 | 393613.1319838057
77 | Name77 | Birta | M2120 | M656 | 393613.1319838057
79 | Name79 | Birta | M2120 | M656 | 393613.1319838057
81 | Name81 | Birta | M2120 | M656 | 393613.1319838057
82 | Name82 | Birta | M2120 | M656 | 393613.1319838057
87 | Name87 | Birta | M2120 | M656 | 393613.1319838057
88 | [NAME] | Vogaskóli | M2125 |  | 393613.1319838057
89 | Name89 | Vogaskóli | M2125 |  | 393613.1319838057
90 | Name90 | Vogaskóli | M2125 |  | 1144125.131983806
93 | [NAME] | Nóaborg | D147 |  | 252784.1450580297
95 | Name95 | Birta | M2120 | M656 | 393613.1319838057
97 | Name97 | Birta | M2120 | M656 | 393613.1319838057
99 | Name99 | Funaborg | D117 |  | 202650.1782591093
100 | Name100 | Funaborg | D117 |  | 239722.5562591093
106 | Name106 | Birta | M2120 | M656 | 393613.1319838057
107 | [NAME] | Birta | M2120 | M656 | 393613.1319838057
108 | Name108 | Birta | M2120 | M656 | 393613.1319838057
109 | Name109 | Heiðarborg | D126 |  | 217125.1909919028
110 | Name110 | Birta | M2120 | M656 | 196806.5659919028
111 | Name111 | Heiðarborg | D126 |  | 236985.1359919028
112 | [NAME] | Birta | M2120 | M656 | 196806.5659919028
113 | Name113 | Ösp | D164 |  | 513691.1919838056
114 | Name114 | Fellaskóli | M2143 |  | 393613.1319838057
119 | Name119 | Birta | M2120 | M656 | 393613.1319838057
121 | Name121 | Ingunnarskóli | M2168 |  | 393613.1319838057
123 | Name123 | Birta | M2120 | M656 | 393613.1319838057
124 | [NAME] | Birta | M2120 | M656 | 354251.818785425