Y yaelcohen Member Jun 16, 2016 #1 Hello expert, I really do not know why I do not find the way to do it with SUMIFS but the only thing I want is - for each line please sum the columns that are =>5 I attached a file with an example Thanks for any help Attachments Question28.xlsb 9.1 KB · Views: 7
Hello expert, I really do not know why I do not find the way to do it with SUMIFS but the only thing I want is - for each line please sum the columns that are =>5 I attached a file with an example Thanks for any help
N NARAYANK991 Excel Ninja Jun 16, 2016 #2 Hi , A simple SUMIF should do : =SUMIF(A4:D18,">5",A4:D18) If you wish to do it row by row , enter the following formula in E4 , and copy down : =SUMIF(A4:D4,">5",A4:D4) Narayan
Hi , A simple SUMIF should do : =SUMIF(A4:D18,">5",A4:D18) If you wish to do it row by row , enter the following formula in E4 , and copy down : =SUMIF(A4:D4,">5",A4:D4) Narayan
S shirley-gstm New Member Jun 16, 2016 #3 You can use the SUMIF formula on each line: =SUMIF(A4:D4,">=5",A4:D4) When I first tried this, I got some strange totals but then noticed that your actual numbers are not integers. Do you want to think about rounding the numbers either in the source or the total?
You can use the SUMIF formula on each line: =SUMIF(A4:D4,">=5",A4:D4) When I first tried this, I got some strange totals but then noticed that your actual numbers are not integers. Do you want to think about rounding the numbers either in the source or the total?
Y yaelcohen Member Jun 16, 2016 #4 You are right Shirley, I will check the real numbers and not the rounded numbers. Thanks a lot!
N NARAYANK991 Excel Ninja Jun 16, 2016 #5 Hi , The problem is not with numbers getting rounded ; the problem is merely with the cell formats which are not displaying any decimals. Correct the cell formats. Narayan
Hi , The problem is not with numbers getting rounded ; the problem is merely with the cell formats which are not displaying any decimals. Correct the cell formats. Narayan
