Count two values in different cells within the same row

[rhettblaine]

Hello all,

I'm trying to count how many times two different values appear in the same row and return those results in the same row. My obvious go to was COUNTIFS but that only works when it's one criteria; once I add an additional Criteria it will return 0. I've tried using SUMPRODUCT but receive the same results.

I also did not create the data source (A1 to H4 in my example below) so I'm having to get creative (I1:L4) so that I can create graphs, etc.

Due to the sensitivity of the data, I cannot post an exact replica of my table.

A

B

C

D

E

F

G

H

I

J

K

L

1

Customer

Order Date

Item 1

Status 1

Item 2

Status 2

Item 3

Status 3

T-Shirt

Pending

Delivered

Canceled

2

Customer 1

Nov 4, 2022

T-Shirt

Pending

Hoodie

Delivered

Hat

Canceled

1

1

0

0

3

Customer 2

Nov 5, 2022

T-Shirt

Delivered

T-Shirt

Pending

Hat

Pending

2

1

1

0

4

Customer 3

Dec 12, 2022

T-Shirt

Canceled

T-Shirt

Canceled

T-Shirt

Delivered

1

0

1

2

 

[Fluff]

In that case can you post some sample data that shows the problem.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.