Count multiple values in cell with range criteria

**leanne13** · 04-30-2009, 08:08 PM

Hello,

I'm trying to figure out how to count by two criteria, only one of the criteria has a value among multiple values in a cell and the other is a range. I tried to use sum but it doesn't count the value and count doesn't recognize the range. I attached the file so you can see what we're trying to do. Please help!!

Leanne

**martindwilson** · 04-30-2009, 08:36 PM

you have a few issues, dates in some cells arent real dates but text thats why there's #value! in them
once thats fixed you can use sumif with wild card for total

**leanne13** · 05-05-2009, 05:10 PM

Thank you so much for your response...Only thing we don't need the sum of the days rather we need a count of the number of cases over 60 days from child's placement with what documents are pending.

So in the spreadsheet, there are 4 cases over 60 days that have PRIDE pending. We have multiple spreadsheets (around 20 of them) so it would be nice to have a formula so we don't have to handcount every time.

I tried some other formulas out...still doesn't work.