Count as separate entries

[Nae2016]

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.

Thanks for your help.

[NeedForExcel]

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"))

[Khalidngo]

Hi,

Or similar to Dave's, but with COUNTIFS:

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

Blessing

[Nae2016]

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