Count cells with values smaller than a given cell

**Joel_FH** · 11-16-2009, 02:44 PM

Hi all,

Does anyone know how to count the number of cells, in a given row, that contains numbers smaller than a value in a given cell, in the same row, in Excel 2007?

I've tried "=COUNTIF(DE61:WV61;"<DD61")", but I'm not sure if it works, some values don't look right...

In addition to this, I don't know how to quickly copy the formula to the rest of the rows (just change the numbers). I've got a large dataset, ca 5000 rows and 500 columns, so I'd prefer not to do it manually...

Best regards,

Joel

**NBVC** · 11-16-2009, 02:47 PM

Try:

=COUNTIF(DE61:WV61;"<"&DD61)

to copy formula down... select the cell with the first formula, then click, hold and drag the little black box at bottom right corner of cell to the point you want your formulas copied down to.

Count cells with values smaller than a given cell

LinkBack

Thread Tools

Rate This Thread

Display

Count cells with values smaller than a given cell

Re: Count cells with values smaller than a given cell

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions

X vBulletin 4.1.8 Debug Information