Help with Sumifs and countifs function

[Sailadarohit]

Hi Team,

Book1
	A	B	C	D	E	F	G	H
1	Department	Crticality	Owner	Jan	Feb	Mar	Aprl	May
2	Sales	Yes	Self	18605	12053	18196	13759	19464
3	Marketing	No	Client	14093	16371	17280	14759	15277
4	HR	No	Client	14322	16203	19954	11030	13283
5	Finance	Yes	Self	15281	18312	17670	13145	16758
Sheet1

I am unable to use sumifs and countifs for an array. Lets say i require the total sum and count for the criticality Yes and Owner Self for all the months mentioned. How can i do that using sumifs and countifs. If we have any other method as well please let me know.

Thanks in advance!!

 

[SunnyAlv]

If u dont want to use Sumifs/Countifs, try this

Count =

=COUNT(FILTER(D2:H5,(B2:B5="Yes")*(C2:C5="Self")))

Sum =

=SUM(FILTER(D2:H5,(B2:B5="Yes")*(C2:C5="Self")))

 

[Dave Patton]

With Excel's older versions try SumProduct

T202404.xlsm
	A	B	C	D	E	F	G	H	I		K	L
1	Department	Crticality	Owner	Jan	Feb	Mar	Aprl	May
2	Sales	Yes	Self	18605	12053	18196	13759	19464			163243	163243
3	Marketing	No	Client	14093	16371	17280	14759	15277
4	HR	No	Client	14322	16203	19954	11030	13283
5	Finance	Yes	Self	15281	18312	17670	13145	16758
6
3b

Cell Formulas
Range	Formula
K2	K2	=SUMPRODUCT((B2:B5="Yes")*(C2:C5="Self")*(D2:H5))
L2	L2	=SUM((B2:B5="Yes")*(C2:C5="Self")*(D2:H5))