Help determining correct formula

[excelmaster5000]

Hello,

I am working on a spreadsheet for my company. Can someone take a look at my attachment and tell me what formula I can use to calculate the proper totals? I can't figure it out and I have to have this done soon.

I made the cells RED that I need formulas in.

Thank you SO MUCH!

[teylyn]

The best way to total this up would be with a pivot table.

Do you want to count approved loans handled by Bob or do you want the total amount of all approved loans handled by Bob?

For counting use formulas along the lines of

=SUMPRODUCT(--($B$13:$B$17=$A4),--($G$13:$G$17=B$3))

Adjust ranges to what you want to count, i.e. for Cross Sales you need the last parameter to be just ($H$13:$H$17)


For summing, use something along the lines of ...

=SUMPRODUCT(--($B$13:$B$17=$A4),--($G$13:$G$17=B$3),(($C$13:$C$17)+($D$13:$D$17)+($E$13:$E$17)+($F$13:$F$17)))

[shg]

If your question has not been answered, please start a new thread with an appropriately descriptive tile.

Thanks.