if.

  1. K

    Lookup values with two multiple criterias

    Dear Experts, I have a data sheet, as i attached a link of image below. C3:J3 has dates from 19/2 till 27/2. <tbody> Cell Address Code Consumption Range Expected Purchase Range A4 01040001 C8:J8 C5:J5 A12 03010003 C16:J16 C13:J13 A20 11030009 C24:J24 C21:J21 </tbody>...
  2. S

    nested countif/if statement

    I'm trying to write a nested statement in Table B Cell B2 to count the number of instances of "no" in Table A Cells B2:B9 if the values in Table A Cells A2:A9 equal the value in the Table B Cell A2 . Table A <TABLE style="WIDTH: 116pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0...

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