Do Not Sell My Personal Information Jump to content


Microsoft Excel Help Required


Recommended Posts

I'm trying to do a count as below ( actually want to do it on dates but can't get it to work on numbers ) ...... pretty easy to explain

A1 - 5

B1 - 4

B2 - 5

B3 - 6

C1 - in here I want to count the number of entries in B1:B3 that are less than A1 ( answer should be 1 ).

I've tried countif but it won't recognise the A1 cell, will work with a constant though or = to a cell.

Any ideas? It's quite a complex spreadsheet so i can't go setting other cells first :(

Link to comment
Share on other sites


OK - hadn't fully understood the problem.

See what you mean about COUNTIF.

=FREQUENCY(B1:B10,A1)

is close except that it includes the case where values are equal - i.e. <=, not just <. You could use the this and reference A2 instead of A1 where A2 = A1-1.

Other option is to add another column that holds 1 if less than, 0 if equal or above and sum the column.

Good luck. Excel is wonderful most of the time and a pain in the a** for the rest.

Link to comment
Share on other sites


Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...




Forums


News


Membership