#countifs

  1. S

    COUNTIFS function not working correctly?

    Hi there, I am having some trouble using the COUNTIFS function. I want to determine whether a certain combination of responses occurs in cell pairs. For example: = SUM(COUNTIFS('P2'!B7,{"Sometimes","Often","Always"}, 'P2'!C7,{"Sometimes","Often","Always"})) When I try the formula in full...
  2. M

    Count value when the value is a merged cell

    Hello, I'm a newbie to type VBA code. Recently, I would like to create a series of VBA code in order to accelerate work. Now, I have faced the problems below: 1. I would like to count the number of "LTG" which has 3 merged rows only.(shown in the uploaded image) 2. About the Find Function, I...
  3. M

    COUNT DUPLICATES IN MULTIPLE CRITERIA

    Hello. I am trying to find the correct formula to count duplicate entries with multiple criteria's. See example below. I need a formula to count all Orders in a spreadsheet that has certain words in that column as well is certain words in another column. I need to find out how many Orders I...
  4. R

    How do I copy formatted values and paste without formatting?!

    I have a date/time stamp column that is formatted as (ddmmyyyy hh:mm:ss AM/PM). The big picture is that I am trying to convert this data so that it can be counted and plotted. Where I am stuck is after reformatting this field into only the military hour, I cannot copy and paste that value into...

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