Forum Discussion
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!!Svein Tore Kristensen See attached!
Okay, thanks. 🙂
But if column (G, H and I) should count the number of trips ex. ("Driver 1" column G),
in this case 2 trips in A, 1 trip in B, and 2 trips in Chow can it be then?
See Attached file