CountIf True

[luisitocarrion1900]

=COUNTIF(Data[Column1],TRUE)

I have the above mention formula but i want to modify it to add that if Counts of Assets in BU is blank dont count the true

now is counting 1,221 but it should be 1177

 

[Fluff]

Have a look at COUNTIFS
https://exceljet.net/excel-functions/excel-countifs-function

 

[luisitocarrion1900]

I did but now is counting base on the helping column true but i want it to add that if the header named "Counts of Assets in BU" is blank don't count it

 

[Scott Huish]

Adjust your ranges, but you can use COUNTIFS

Excel 2010
	A	B	C	D	E
1	Data	Counts of Assets in BU			1
2	TRUE
3	TRUE	42
Sheet1

Cell Formulas
Range	Formula
E1	=COUNTIFS(A:A,TRUE,B:B,"<>")