Notifications
Clear all
Topic starter
hello
may you please help, I want to count how many dogs and donkeys to find out how many are black and how many are brown but I want to omit cats and horses
Posted : 11/12/2021 1:00 pm
Hello,
You can use the database function DCOUNT or you can use SUMPRODUCT to get what you want.
See attached file for examples.
Br,
Anders
Posted : 11/12/2021 6:49 pm
You could also use something like:
=SUM(COUNTIFS(B:B,{"Dog","Donkey"},C:C,"Black"))
Posted : 14/12/2021 7:18 am
