count if or sum if formula

kumar1803

Board Regular
Joined
Jan 7, 2015
Messages
110
Hello

I am trying to count all my past due deals by type

Column A (Type) Column B ( # of days)

Wholesale 8
5
9
2

Cash 9
5
4
1
8

Finance 2
3
5
8
0
-1

In a nutshell, I would like to count past due of any deals greater than or equal to 8 days above in column B by Type (column A)
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,926
Office Version
  1. 365
Platform
  1. Windows
Would this do?
Formula in C2 copied down to the end of the data. ($2000 in the formula should be greater than the number of rows you will ever have)

Excel Workbook
ABC
1TypeDaysNo. >= 8
2Wholesale82
35
49
52
6
7Cash92
85
94
101
118
12
13Finance21
143
155
168
170
18-1
19
kumar1803
 

Watch MrExcel Video

Forum statistics

Threads
1,122,356
Messages
5,595,681
Members
414,009
Latest member
SNesbyCarr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top