Count based on another column
 

I'm trying to get a count of a row based on a letter entered into the cell in
the next column

Ex:
A B C
Day
H/B Work Order
1 H 24757
2 B 10146
3 H 25468
4 Yard

I want it to count the the days with a number in Column C for H from column
B & the total of B from ComopunB. So there would be 2 totals for C. I don't
want it to count it if it says Yard

Thanks,
Chance

Here is a simple brute force approach:
In D2, =IF(B2="H",1,0)
In E2, =IF(B2="B",1,0)
Copy those formulas to rows 3..x
Then sum at the bottom.

"Chance224" wrote:

I'm trying to get a count of a row based on a letter entered into the cell in
the next column

Ex:
A B C
Day
H/B Work Order
1 H 24757
2 B 10146
3 H 25468
4 Yard

I want it to count the the days with a number in Column C for H from column
B & the total of B from ComopunB. So there would be 2 totals for C. I don't
want it to count it if it says Yard

Thanks,
Chance