rfigueroa1976
New Member
- Joined
- Jan 10, 2019
- Messages
- 14
Trying to get a count of orders that were shipped out of a city during a year and month listed in another cell...
Countifs city in column B:B is the same as f2, state in column C:C is the same as g2, Month in Column d:d is the same as the month in the date in f3, Year in Column d:d is the same as the month in the date in f3.
The formula i currently have is =COUNTIFS(B:B,F2,C:C, G2) but still need to add the month and year portion of the formula.
I'd attach a worksheet but I currently don't have permission to do so.
Countifs city in column B:B is the same as f2, state in column C:C is the same as g2, Month in Column d:d is the same as the month in the date in f3, Year in Column d:d is the same as the month in the date in f3.
The formula i currently have is =COUNTIFS(B:B,F2,C:C, G2) but still need to add the month and year portion of the formula.
I'd attach a worksheet but I currently don't have permission to do so.