Count using offset, index, match

editof

New Member
Joined
Sep 18, 2020
Messages
2
Platform
  1. Windows
Capture.PNG

I need to count how many "1" has appeared in column E When column D is between 01-07 using offset, index, match. It doesn't have to be all of it, but the combination of it.
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,273
Office Version
  1. 365
  2. 2010
Welcome to Mr. Excel.

What about:
Code:
=SUMPRODUCT((D:D>=1)*(D:D<=7)*(E:E=1))
 

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,273
Office Version
  1. 365
  2. 2010
Why? Don't you just want a good solution?
 

Watch MrExcel Video

Forum statistics

Threads
1,112,816
Messages
5,542,660
Members
410,567
Latest member
SCraig123
Top