Sumif not working

[makinmomb]

I have commonly been using SUMIF on msoffice , it is not working on EXCEL 365

Need expected results 6 and 4

See file attached

[AliGW]

Where is the formula?

Please provide a workbook with the formula you have tried. SUMIF works the same in Excel 2010 as it does in 365.

Maybe you have forgotten that you need COUNTIF instead???

=COUNTIF($D$1:$D$11,K1)

If you have updated your Excel, then you need to update your forum profile, please.

[Pepe Le Mokko]

You need to use the COUNTIF function, not SUMIF

[makinmomb]

Thank AliGW , simple and neat

[AliGW]

Please update your forum profile NOW.

It's just a case of picking the correct function! You can't count with s SUMIF function - the clue is in the name.

[makinmomb]

I put those 1's for i know SUMIF so i dont even need to plug those 1 for i was expecting SUMIF to do the sum , i got u clear , thank you again

[AliGW]

PLEASE update your profile NOW.

[makinmomb]

Edit done for excel kind i am using at work

[junmacs]

You can use COUNTIF in your attached excel.