Forum Discussion
Hei
Hva gjør jeg feil her?
Se formler i rosa celler
Takk for svar
Mvh Svein Tore
11 Replies
Have a look at your revised file attached. Made your formulae dynamic, meaning that you don't have to hard-code the driver numbers that you already have in column B and row 6. Note the use of the $ signs. These freeze parts of column and row references, enabling you to drag the formulae down and across.
Then you tried to use SUM to count the number of occurrences of A, B and C. You should use COUNTIF(<range>,<criteria>) to achieve that.
Trevlig Helg!
Great!!
Thank you so much
that was exactly what I was looking for
Have a nice day!! 🙂Only 1 problem
=ANTALL.HVIS(G$7:G$13;$F18)
must count the number tours in "F"
how is the formula then?
Have a nice day!!
