Multiple criterea in a countif

Hi, first time here looking for some aid after i have not been able to find what i need through google.

Im looking to creat a function to count text entries only if that text entry is matched with a different text entry in a different column but in the same row.

Say A has multiple entrys and will continue to expand, and im looking for every entry that says "Club" then i get =countif(A:A,"Club") and it gives me the result i need, but what i need is it to count only the "Club" from column A that have the word "Good" in the same row but from column C.


Thanks for any and all help.

=SUMPRODUCT((A1:A3="Club")*(C1:C3="Good"))

side note, is there a way of doing it so it includes the entire column? like doing A:A or does it have to include a number such as A2:A1000 ?

You must always specify the range of cells ina formula.

If you use Dynamic Named Ranges as the range reference in the formula then the formula will automatically adjust itself for any addtions/deletions in the ranges of cells being evaluated.

If you name a range of cells in column-A as "Clubs" and column-C as "Status", then the formula would look something like this:

=SUMPRODUCT((Clubs="Club")*(Status="Good"))

Do a search on Dynamic named Ranges for more information

Thank you very much Palmetto you have been more than helpful!

My pleasure.