formulae count if

  1. P

    Help with counts formula

    Hi I would like to count how many instances cells within column C do not equal a named range with a second criteria, something like this: =countifs(C:C,"<>"&NamedRange, D:D,"1") Is this possible? Many thanks
    • p4nny
    • Thread
    • countif 2 conditions met equal formulae count if named range
    • Replies: 4
    • Forum: Excel Questions
  2. B

    How do I count number of occurences in the last 4 months?

    I have hundreds of names in, say, column A and the date I saw that person in, say, column B. The data goes back several years. What I am after is a way to count the number of times I have seen each person over, say, the last 4 month period. I might need to extend this to six months. Can a...
  3. N

    Excel for summarizing/arranging data

    hi, i have been an assignment by my teacher to arrange data in excel. the data is about some type of customer database which contains ID of Customer, Outgoing calls, Incoming calls and sms, each customer ID Making several calls the data should be arranged in such format Customer ID...
    • naar
    • Thread
    • data management excel formulae count if
    • Replies: 16
    • 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