sumif returning correct total while sumifs returns #value

Hello,

I'm new to the forum but have used the information a lot in the past to help solve some issues I've had with Excel and my sales reports.

I've used sumif and sumifs at length to create a variety of different reports from our database. That being said I've run into a problem with a new report I'm creating.

I need to create totals based on multiple criteria. When I use the sumifs formula as I have in the past, I receive a #value in the cell. Without changing any formatting, I use the sumif function on the one criteria that seems to be the problem and it returns a correct total.

Example:

=sumifs(quantity,companyname,$a2,price,">65") returns #value

=sumif(companyname,$a2,quantity) returns the correct total

Has anyone had this problem in the past?

Thanks,

Mike

Thank you but it is still returning #value

Thanks but same result

Problem solved. thanks for the help.