complex countif

  1. B

    Using CountIf Using Variable Rows

    I am trying to use CountIf, but making the Range using a formula to find a row in another sheet. It is a little bit complex and I haven't found any examples or advice on how to do this correctly on any tutorials. I am hoping someone here could help me figure this out. Here are the two sheets...
  2. S

    counting

    my table is like below I need to count how many r there are for all process only for Quality (5) I need to count how many r there are for all process only for SHE (2) etc Many thanks for any help <tbody> Process Day 01 02 03 04 05 06 07 08 09 Process 1 Quality n r g a r g g a g Process...
  3. D

    complex array formula

    I have two workbooks like the ones shown below. I am looking for single formula and no vba to calculate regular time in columns d3:d9 g3:g9, i3:i9 in workbook 2 sheet 2 based on the date, ID, and the criteria listed below. I also cannot have any additional helper columns. I am have trouble...
  4. M

    Complex, Countif 2 conditions met

    Hi All, I am looking to combined these two countif statements below to get a new =countif(Statement1 AND Statement2), I can't seem to figure out a formula that will work.. is this possible? Or is there a better way to do this? Statement 1 =COUNTIFS('Paste Key Survey Results'!F:F, "Yes")...
    • msiegal
    • Thread
    • complex countif countif countif 2 conditions met countif range countif this and that
    • Replies: 21
    • Forum: Excel Questions

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