countif and vlookup

  1. H

    Non-Contiguous COUNTIF range

    Hello All, I am struggling to find a way to COUNTIF the rows label 'Qty' are less than a value. I have tried naming the range but COUNTIF doesn't seem to work on a named range. Ultimately I would like formulas to for Qty < 30, Qty < 40, etc. I would do the same with time (formatted in m:ss)...
  2. D

    COUNTIF and VLOOKUP in VAB

    Hi, i need help counting the number of time a value appears. Programmed with VBA Here is an examples. [/URL][/IMG] Exercise 1 So let say i need to count the number of time "Finished" Shows up based on the month. Here is an example of what I'm trying to achieve [/URL][/IMG] I'm not sure what...
  3. B

    Countif + vlookup

    Hi 1st Time posting, Sheet 1 has a table with 5 columns (Name (A1), Date (B1), Type of Occurrence (C1), Reason (D1), (Un)Excused (E1)), the fields are filled through questions through a user form. The contents will vary within a set number of values from the above mentioned. On Sheet 2 I have...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top