# Count as separate entries

1. ## Count as separate entries

Hello.

I really hope this is going to make sense ...

I need a formula to calculate the B and X lines, but only count them if there is a X in the same row.

I have a formula that will count the B but instead of having 2 x b/x and 1 x b it is adding it all up so my counts are 2 x b/x & 3 x b, this is inaccurate for my reporting.  Register To Reply

2. ## Re: Count as separate entries

So basically you want to count the number of rows only if Column B has a B and Column F has an X on the same line.

So in the attached file, such is the case 3 times? Am I right?

If that is what you want, try this

=SUMPRODUCT((\$B\$2:\$B\$700="B")*(\$F\$2:\$F\$700="X"))  Register To Reply

3. ## Re: Count as separate entries

Hi,

Or similar to Dave's, but with COUNTIFS:

=COUNTIFS(B2:B700,"B",F2:F700,"X")

Blessing  Register To Reply

4. ## Re: Count as separate entries

Thank you for the input. I must be doing something wrong? I cant get the formula's to provide an accurate count.  Register To Reply