I need help with COUNTIFS
function.
There are values in column B
: a,b,c,d,e,f,....
I want to use COUNTIFS
function to count items in column A
, if the values in column B
is included in range {a,c,f}
I need help with COUNTIFS
function.
There are values in column B
: a,b,c,d,e,f,....
I want to use COUNTIFS
function to count items in column A
, if the values in column B
is included in range {a,c,f}
To count how many times a,c or f appear in Column B use:
=SUM(COUNTIFS(B:B,{"a","c","f"}))
To sum the values of Column A where a,c or f appears in Column B use:
=SUM(SUMIFS(A:A,B:B,{"a","c","f"}))