Print total number of vowel and consonant in an entered sentence
Some thoughts:

choose good names

counter is IMO a bit "generic". Perhaps something more expressive like count_vowels_consonants?

Moreover, the inner function's parameter is named count, but it's actually not some count (number) but a text string.

Furthermore you're using the term "sentence", but you're not actually requiring sentences, but rather character sequences / strings.

don't call the function twice

find_total(count_sentence)
vowel_total = find_total(count_sentence)


Here you call find_total, discard its result (return value) and then call it again, this time assigning the result to the local variable.

separate calculation and output

Instead of

print("Vowel: {0}, Consonant: {1}".format(vowel_total, consonant_total))
return


leave out the print and return the values in a tuple

return (vowel_total, consonant_total)


On the caller side, you can then either use the returned tuple as it is

t = count ("foo bar")


or for example use tuple unpacking to obtain the individual counts

vowels, consonants = count ("foo bar")


only iterate once over the characters

Instead of first going one time over the characters to filter out non alphabetic characters and adjust the case of the alphabetic ones and then a second time to count, do it in one loop:

def count_vowels_consonants(text):
  vowels_list = ['A', 'E', 'I', 'O', 'U']
  consonants = 0
  vowels = 0
  for character in text:
    if character.isalpha():
      if character.upper() in vowels_list:
        vowels += 1
      else:
        consonants += 1
  return (vowels, consonants)


test corner cases

Does your function work well with an empty string? A string with only vowels or consonants? A string with only punctuation?