0

Problem I want to count uniquely in multiple criteria but it seems the formula isn't working The count should be 6 instead of 3.5 what should I do?

Improve this question
1
  • Please Edit your question and give all the details (criteria, output/result, etc).
    – Reddy Lutonadio
    Commented Mar 26, 2022 at 8:18

1 Answer 1

Reset to default
0

Simply use COUNTIFS function. Adapt the following formula to suit your range:

=COUNTIFS(A1:A5,D2,B1:B5,E2 & "*")

enter image description here

Improve this answer
2
  • Thanks but it will cause another problem that if in column B1 contain C-1, B2 contain C-1 B4 contain C-2 and B4 contain C-2 the formula should just count C-1 and C-2 one time for each so the result should 2 not 4. Do you understand my explanation but thanks for the answer anyway.
    – patcharita
    Commented Mar 26, 2022 at 8:09
  • @patcharita Then your criteria is C-1 not C-.
    – Reddy Lutonadio
    Commented Mar 26, 2022 at 8:22

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .