Sum If or Count if help required

[nischal4487]

Hi,

I have a Column which has names to rows

Name Days
John 10
Mike 15
Mike 10
John 2
Stella 20
Stella 4
Martin 30
John 20
Mike 30

I need the result total of days as below

Name Days
John 22
Mike 55
Stella 24
Martin 30


Kindly help.

 

[nischal4487]

Hi, Thank you for your quick response . I am finding the query hard . Could you please provide the Sumif formula based on the sheet below,

 

[sandy666]

see link to SUMIF function in post#10
or
if you've more conditions use

SUMIFS function - Microsoft Support

How to use the SUMIFS function in Excel, one of Excel’s math and trig functions, to add arguments that meet multiple criteria.

support.microsoft.com