SUMIFS formula not workink

[ariful.rbg]

Hi everybody

I'm working with a Excel Sheet where I want to use SUMIFS formula but its not working, I can't understand whats the problem. I'm attaching my file. in this file for SUMIFS I use this Formula "=SUMIFS($Z$19:$Z$300,$A$19:$A$300,C1)". I need your help. plz hel me

[shirleyxls]

The data in column Z are not numbers.

I'd suggest that you create a new column and put the formula =Z20+0 (for example) then format as numbers to 2 decimal places, then use this in your SUMIFS formula or select column Z and use the Text to Columns feature to convert them to numeric values.

[JohnTopley]

Simple ... your data is TEXT not Numeric: Change to Number or General

[ariful.rbg]

Thanx for help shirlyxls and John Topley