Count cells with values smaller than a given cell
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
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.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks