countif and if formula

  1. J

    Extensive Excel Formula

    Please see below screenshot. Column J and I are the ones where I need help with. I have tried "countifs" with multiple scenarios, yet cannot get to work exactly how I picture it. * Does the customer have one contract with one service type for the entire year? If so, return SYSR (Single Year...
  2. C

    Stuck on countif

    I can't seem to get a count if formula to work. I have a range of cells see below. I would like to count the number of times a value is in a cell such as "01" or "24" The formula returns zero count because I believe it is looking for only the "01" or "24" and if the cell contains other...
  3. A

    Countif and IF Formula

    I am using the following formula =if(countif('Copy of Portfolio Transactions'!$A:$A,"Avondale Tax*"),'Copy of Portfolio Transactions'!F3,"") The F3 Row is a dynamic field not static and every time I move the data around I do not get the results. Is there a way I can make it dynamic?

Watch MrExcel Video

This Week's Hot Topics

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
Top