SumIf and Data Validation
 

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!

SumIf and Data Validation
 

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)


"Mike" wrote in message
...
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!