Count if

[Imran Azam]

HI Guys

i have the data below

group	ID	Department	products
A	1	sales	pc
A	2	marketing	pc
A	3	marketing	ons
A	4	HR	pc
A	5	marketing	tons
A	6	marketing	pc
B	7	sales	pc

<colgroup><col span="2"><col><col></colgroup><tbody>
</tbody>

I want to do a count if , using this logic , count the ID where Group = A, department is not 'sales' and product is not 'tons' or 'ons' ( basically i want to exclude the product ons and tons in the count)

so the answer should be 3

can this be done?

thanks for any help

****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

tons

<tbody>
</tbody>

</body>

 

[Finalfight40]

Re: Count if help

Something like this?

=COUNTIFS(A2:A8, "A", C2:C8, "<>" & "Sales", D2:D8, "<>" & "ons", D2:D8, "<>" & "tons")

 

[Imran Azam]

Re: Count if help

thanks