If Function for Letters not Numbers

[Sherif Osman]

The Problem is as follows:


12 MARCH JOHN 50,000
13 APRIL MARC 40,000
18 JUNE BILL 30,000
20 JUNE AMY 10,000
23 JUNE BILL 40,000
30 NOV MARC 55,000


i just want to Calculate how much Marc or bill or etc.
earns during the whole year and post the (sum) in another
cell(it will be in another excel page actually), thus any
day bill or marc ... earn it automatically accumulate the
this new no. with the history (sum) of the amount already
exsist in the cell (other page).
P.S the input here is names not numbers, i want to get the
whole sum when i write Bill/Marc/AMY earns something new.

P.S it is not the filtering tool what i need ok.


IS IT IF formula or what ?

 

[JulieD]

Hi Sherif

use SUMIF
e.g.
=SUMIF(C1:C1000,"JOHN",D11000)
where column C contains your names & column D contains the figures to add
up.

Cheers
julieD
PS if its on another sheet you need to reference the sheet in the formula or
better still use range names.

 

[Ken Wright]

Only thing I'll add to the posts you already have is that you may want to
investigate the SUMPRODUCT function which will allow you to specify more than
one criteria, something that SUMIF will not allow you to do. Also, if those
dates aren't real dates in the sense that Excel understands a real date then I
would fix that first and then go from there.