If with multiple criteria

[McKenK]

I am trying to get results for a report where I need a column of figures to add up depending on who/where they are assigned. I have values in column B, Account Manager in column E and Hotel in column F. If Acc Manager AG has revenue at Hotel AMC the I need to values to add. The formula I am using is =SUM(($E$2:$E$261 = "AG")*($F$2:$F$261 = "AMC")*$B$2:$B$261) but it not rerutning a result. Could you let me know where I am going wrong please

 

[SteveO59L]

Possibly try a Pivot Table

 

[McKenK]

Sorry, a bit of a Pivot Table virgin, how do I do that please