Using COUNTIFS for counting multiple criteria

[MusoFreak200]

G'day, thanks for reading.
ok here is my problem. I have a timetable in excel which I am counting the hours for cells in the right hand side under categories. I am attempting to combine different types into single counts.

I have been having trouble and have thought about using the following statement however it is not working

=COUNTIFS(B3:H22,"*Quiz*",B3:H22,"*Test*",B3:H22,"*Assessment*")

Where am I going wrong?

[Rabbit]

In what way is it not working?

[MMcCarthy]

The COUNTIFS function does not work this way. It allows you to select multiple criteria. So your formula would only give a results if all 3 were true. I would recommend instead using multiple COUNTIF functions as follows:

=COUNTIF(B3:H22,"*Quiz*")+COUNTIF(B3:H22,"*Test*")+COUNTIF(B3:H22,"*Assessment*")

That should give you the result you want.

[MusoFreak200]

Thank you mate I knew I was poking too closely at it.
However is there a way to get it to count regardless of the text case

[MMcCarthy]

I'll have to think about that one, leave it with me.

[MMcCarthy]

I just double checked it and COUNTIF is not case sensitive so it should find the text regardless of case.

[MusoFreak200]

That's odd Oh well thank you for your help