Booking system formula

Hi I’m new here.

I have been having a problem. I am making a booking in system on excel. I have got a front end to it, where people enter there data. And a macro which brings the information to the back end of the spreadsheet.

I need a formula which looks up in the above fields and counts how many there are of a course name example: “course 1a” = 5 and in the next box “course 1b = 1.

I Don’t know which formula to use. Will it be a lookup or will it be a counta formula. Or is it a formula with both in it. I have been trying for the last few days.

Please someone help me


Cheers



John

yes yes it does mate.

cheers for that i have never used a countif before.

Your a star

Assuming your range of data holding the text "course 1a" etc. is in A1:A100
In B1 enter Course 1a, in B2 enter Course 1b

In C1 enter =COUNTIF($A$1:$A$100,"="&B1)
copy down to C2


--
Regards
Roger Govier
"johncouzins" <johncouzins.1ss2qi_1122383117.9197@excelforum-nospam.com>
wrote in message
news:johncouzins.1ss2qi_1122383117.9197@excelforum-nospam.com...
>
> Hi I'm new here.
>
> I have been having a problem. I am making a booking in system on excel.
> I have got a front end to it, where people enter there data. And a macro
> which brings the information to the back end of the spreadsheet.
>
> I need a formula which looks up in the above fields and counts how many
> there are of a course name example: "course 1a" = 5 and in the next box
> "course 1b = 1.
>
> I Don't know which formula to use. Will it be a lookup or will it be a
> counta formula. Or is it a formula with both in it. I have been trying
> for the last few days.
>
> Please someone help me
>
>
> Cheers
>
>
>
> John
>
>
> --
> johncouzins
> ------------------------------------------------------------------------
> johncouzins's Profile:
> http://www.excelforum.com/member.php...o&userid=25602
> View this thread: http://www.excelforum.com/showthread...hreadid=390165
>