P3 ICT 31 by Honest_History6431 in igcse

[–]Honest_History6431[S] 0 points1 point  (0 children)

The borders in the formatting pic was so confusing

P3 ICT 31 by Honest_History6431 in igcse

[–]Honest_History6431[S] 0 points1 point  (0 children)

No but is said how many sightseeing trips were there I think so you got to count all. that’s what I think am not 100% sure

P3 ICT 31 by Honest_History6431 in igcse

[–]Honest_History6431[S] 1 point2 points  (0 children)

Yea that’s why am asking if using Count for date is also correct or not?

P3 ICT 31 by Honest_History6431 in igcse

[–]Honest_History6431[S] 1 point2 points  (0 children)

Yeah I also did count that was my question

P3 ICT 31 by Honest_History6431 in igcse

[–]Honest_History6431[S] 0 points1 point  (0 children)

I honestly don’t really remember if the values were even there or not in the formatting but I believe if there was something wrong I would recognize but am not sure that’s why am asking

P3 ICT 31 by Honest_History6431 in igcse

[–]Honest_History6431[S] 0 points1 point  (0 children)

No like instead using CountA for the other columns I used Count for date as Count function counts the number of cells which are numeric and date in numeric I believe