excel COUNT formula

Question

I am trying to count how many instances of a specific number occur on one range of cells depending on the value of another range of cells directly left of the count range. I then need to multiply the count value by another cell value, say its value is 172.

So lets say I want to count how many hours are = to 8 when the start time is 6.

Any help appreciated.

Use COUNTIFS() --> =COUNTIFS(B2:B12,6,C2:C12,8)

Mayukh Bhattacharya
– Mayukh Bhattacharya

2025-06-02 19:58:28 +00:00
Commented Jun 2 at 19:58 — Mayukh Bhattacharya
– Mayukh Bhattacharya, Commented Jun 2 at 19:58

Code_Z · Accepted Answer · 2025-06-03 16:02:44Z

0

In your example column "L" is Start and column "M" is Hours. So, I've added cell "N2" as the multiplier your referred to (i.e. 172).

The following formula will perform the Countifs function and count only the 8's when the adjacent cells contain a 6, and assigns the output to the "hours" variable, then assigns N2 to the "multiplier" variable, and finally it will multiply both variables together. In your example the output of the formula would be "344".

=LET(hours, COUNTIFS(M2:M12,8,L2:L12,6),multiplier, N2,multiplier * hours)

edited Jun 3 at 16:02

answered Jun 3 at 15:54

Code_Z

915 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

excel COUNT formula

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related