I have a spreadsheet with one page for my report and another page that holds
my data that is updated on a regular basis so I automated it.

The problem is my formula only recognizes numbers and the data contains
numbers and text. I use sumif because there is not any repeated data.

Here is my formula:

=SUMIF('Morning Star '!$A$1:$A$25,$N$3,'Morning Star '!B$1:B$26)