We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
Contact Forum Editor

Send an email to our Forum Editor:


PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom


It's free to register, to post a question or to start / join a discussion


 

Excel DCOUNT problem


Neill

Likes # 0

To help me collate my student's marking and passes I use DCOUNT to see if a date is after 1/1/08 and a number is greater than or equal to 24 which then returns a count if both criteria are satisfied.
=DCOUNT(AB4:AD50,AD4,AB58:AD59)
where AB4:AD50 is the data
AD4 is the heading label - Mark
AB58:AD59 the criteria >=01/01/08 >=24
Now this WORKS for 5 of the 7 modules the students take but doesn't work for two of the data ranges. This is driving me mad!! Why does it work perfectly elsewhere but not two columns? I've used Format Painter, redone the formula till I'm blue in the face without any luck.
Does anyone like an Excel problem to solve over Christmas? I can email the spreradsheet if you like!
Cheers

Neill

Like this post
nosharpe

Likes # 0

Are you using Dcount for a non-numeric cell

Like this post
Neill

Likes # 0

I have formatted the data, copied the formulas so the columns are identical (even the Trace Precedents looks identical) but still it refuses to work. So I have now resorted to copying the data from the columns that don't work into a column that does work and it works if you see what I mean.

I hate not knowing why though. Thanks for your help.

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

45 Best Android games: top Android games for your smartphone or tablet in 2014 (24 are free!)

IDG UK Sites

How Apple, Adobe, Microsoft and others have let us down over UltraHD and hiDPI screens

IDG UK Sites

Do you have the X-Factor too? Mix Off app puts fans in the frame

IDG UK Sites

iPad Pro release date, rumours and leaked images - 12.9 screen 'coming in 2015'