How to repeat IF+COUNTIFS function

Ramadan

Board Regular
Joined
Jan 20, 2024
Messages
149
Office Version
  1. 2021
Platform
  1. Windows
I have a formula combining IF with COUNTIFS for multiple ranges and it works smoothly but to check for one sheet only like this =IF(COUNTIFS(District1!B:B,"="&$D5,District1!C:C,"="&$E5),District1!$B$2,"")
to check (IF B:B in sheet District1 = D5 and if C:C in sheet District1 = E5 , so to return Cell $B$2 in district1 sheet otherwise keep it empty)
till now it's ok and the formula works good but I need to repeat it several times to check in other sheets and when i make it like this: =IF(COUNTIFS(District1!B:B,"="&$D5,District1!C:C,"="&$E5),District1!$B$2),IF(COUNTIFS('Carnell'!B:B,"="&$D5,'Carnell'!C:C,"="&$E5),'Carnell'!$B$2),IF(COUNTIFS(Ivory!B:B,"="&$D5,Ivory!C:C,"="&$E5),Ivory!$B$2)))),"") excel doesnt accept it as a formula while i need to repeat it 7 times to check 7 sheets

please let me know how it should have to be ??

thank you in advance
 

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