multiple criteria count

  1. A

    Multiple criteria lookup and add

    Hi everyone, I really need some help as my brain has popped! I have a spreadsheet with three tabs. One is a dashboard to bring together values from the other two. The purpose is to calculate the quantity of items per county so I can determine volumes needed for storage. The sheets are...
  2. P

    count between dates with two criteria

    Hi, I need a formula that will allow me to count the number of account Approved or Active between a date range A B Active 1/01/19 Approved 1/19/19 Active 2/10/19 Pending 2/20/19 Close 3/15/19 Thanks, Carlos
  3. H

    NEED HELP: Countif tie breaker with multiple tie breaker criteria

    I need a formula that will help me rank the 'Jan Var. for rank only' values, ignoring blanks in between rows, in ascending order. So the largest negative will get rank 1, etc. Then if the values in that column are the same, I want to break the tie by looking at which row has the larger number of...
  4. J

    Multiple criteria formula needed

    So, the goal is to find 3 criteria within column D, if column P ( month ) matchs another column on a different tab, count the number on column J The old formula that was used is, "=IFERROR(IF(OR($C5923="Renewal",$C5923="Client Implementation"),0,J5923),"-")" since our CRM has been updated...
  5. A

    Count of multiple criteria

    I hope you can help I am running out of time and I am trying to run a formula which provides a count based on 2 types of criteria Year (Column A) & Type (Column S - which is a multiple pick list option) I have tried =COUNTIFS('SALES'!A2:A100,2012,'SALES'!S2:S100,"*Family*")...

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