# 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.

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

3. ## Re: Count as separate entries

Hi,

Or similar to Dave's, but with COUNTIFS:

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

Blessing

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1