Multiple Column Count

[jlokesh16]

Hello,

I have table below which consist of some values.

A	B	C	D
20170731-1004452312	0	67	0
20170412-1004326973	0	4	0
20170712-1004426409	0	3	0
20170724-1004453214	0	11	0
20170731-1004458586	0	2	0
20170801-1004447554	0	1	0
20170801-1004447746	0	1	10
20170725-1004451557	0	91	0
20170801-1004447981	0	2	26
20170801-1004453408	0	1	0
20170801-1004457821	0	2	0
20170801-1004461544	17	27	56
20170802-1004411805	0	1	0
20170802-1004421295	0	18	0
20170802-1004440258	0	1	0
20170802-1004459871	0	21	0
20170727-1004450401	17	273	0
20170801-1004458819	0	4	0
20170802-1004461693	0	73	0
20170803-1004445438	0	44	0
20170803-1004446584	0	2	0
20170803-1004450607	0	1	0
20170803-1004452430	0	6	0
20170803-1004445948	35	33	0
20170803-1004431587	0	0	286
20170808-1004440441	0	1373	0

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Here I want to calculate the instances where col b & c values are not equal to 0. eg: there are 3 instances where col B & col C values are not equal to 0.

Thanks.

 

[Rick Rothstein]

Give this formula a try (adjust the ranges as needed)...

=COUNTIFS(B1:B26,"<>0",C1:C26,"<>0")