Calculating Totals for each person

[fredieusa]

Hello All,

for the like of me, i cannot get this correct. It first appeared a simple task but it is kicking my butt.

I am trying to get the totals for cash and credit for each person
I want cells E2 to calculate $10 and F2 to calculate $20 for Kumar.

E3 and F3 for Mc Donald and E4 and F4 for Smith, Charged vs cash spent respectively.

 

[Naresh Yadav]

Hi,

Pls try this one

E3 column =SUMIFS($D$13:$D$20,$B$13:$B$20,D3,$C$13:$C$20,"charge")
F3 Column =SUMIFS($D$13:$D$20,$B$13:$B$20,D3,$C$13:$C$20,"cash")

 

[bosco_yip]

Try,

1] Changed heading wording : E1 to "Charge" and F1 to "Cash"

2] In E2, copied across to F2 and all copied down :

=SUMIFS($D$8:$D$100,$B$8:$B$100,$D2,$C$8:$C$100,E$1)

Regards
Bosco

 

[fredieusa]

Sweet, Thanks! what is this formula nomenclature in the book, if i want to read up on it? thanks again.