Forum Discussion

Copper Contributor

Sep 25, 2020

Solved

IF function

Hi i use COUNTIF + AND functions to count the number of some courses. i want to count course and status at the same time. i mean count the number of LANUGUAGE when STATUS is yes. for example there ...

Formulas and Functions

Riny_van_Eekelen
Sep 25, 2020
Reza Dashti That could be:
=SUMPRODUCT(--(C2:C5="language")*--(F2:F5="yes"))
or
=COUNTA(FILTER(C2:C5,(C2:C5="language")*(F2:F5="yes")))
in case you are a MS365 subscriber.

Reza Dashti

Copper Contributor

Sep 25, 2020

Hi Sergei

thanks for your help, but it still does not work with COUNTIFS function. i have attached an image. if you look at cell J2 it still returns zero.

Riny_van_Eekelen

Platinum Contributor

Sep 25, 2020

Reza Dashti That could be:

=SUMPRODUCT(--(C2:C5="language")*--(F2:F5="yes"))

=COUNTA(FILTER(C2:C5,(C2:C5="language")*(F2:F5="yes")))

in case you are a MS365 subscriber.

Reza Dashti
Copper Contributor
Sep 26, 2020
Riny_van_Eekelen
Hi Riny
SUMPRODUCT function solved my problem.
thanks