COUNT/SUM Formula For Mulitple Criteria

[ngor3431]

Hi I'm building a spreadsheet to help track our companies sales progress. Need a formula that will count the amount of customers within each sales process for each salesperson. I tried a SUM CSE formula as below

{=SUM(('RB OUTPUT'!BG:BG="Sales Person 1"),('RB OUTPUT'!BO:BO="Targeting"))}

We have 5 different sales stages. Does anyone have any solutions?

Cheers

[vlady]

Hello maybe countifs

=countifs('RB OUTPUT'!BG:BG,"=Sales Person 1",'RB OUTPUT'!BO:BO,"=Targeting")

=countifs('RB OUTPUT'!BG:BG,A1,'RB OUTPUT'!BO:BO,A2)