countifs with drop down list

Поделиться
HTML-код
  • Опубликовано: 10 окт 2024
  • To make a drop down select the cell where you want to make drop down . then go to data menu and select data valuation and then select list
    and choose the criteria which you want to make drop down
    countifs formula :
    =countifs( criteria range 1, criteria 1 , criteria range 2, criteria 2)
    if you have any question you can ask me at
    my Facebook page : / khan.labab.1

Комментарии •