SumIf and Data Validation

M

Mike

Okay, I'm trying to get the sumif to work with the values in cells that are
set from a list validation. It's either going to be "Debit" or "Credit", but
it isn't working! Neither is countif for "Debit" or "Credit".

Is it because it is a value from the list validation? When I do it in a
separate workbook where I just type out a column with debits and credits, and
assign them random numbers, it works! Just not in the workbook I need it
too. Please help!
 
P

Peo Sjoblom

I have no problems getting it to work, check if you have hidden extra
characters in your list

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top