And while you're at it, make sure that the B array is the same length as the
A array. At the moment, one is 25 long and the other 26.
--
David Biddulph

"Rick" wrote in message
...
Sweetsue,

if the text in N3 is the same as the text in A1:A25, then you shouldn't
have
a problem. Obviously, if there is text in B1:B25 then the sum won't work
so
you need to extract the text out of the performance values.

Can you provide an example of the data on the Morning Star sheet and what
is
in field N3?

Rick

"sweetsue516" wrote:

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)