# Whats wroing with Sumifs formula.

Hi, whats wrong with this fromula. Correct result should be 30.8% but it returns 0%

=SUMIFS($Q$5:$Q$25,$P$5:$P$25,">=4",$P$5:$P$25,"<=6")

Thank you

First time here? Check out the FAQ!

Whats wroing with Sumifs formula.

Hi, whats wrong with this fromula. Correct result should be 30.8% but it returns 0%

=SUMIFS($Q$5:$Q$25,$P$5:$P$25,">=4",$P$5:$P$25,"<=6")

Thank you

Asked: ** 2019-04-19 12:35:15 +0200 **

Seen: **41 times**

Last updated: **Apr 19 '19**

How do I export a chart in an image format from LibreOffice Calc? [closed]

Are there plans for a "papercut" project for libreoffice [closed]

Is it normal for Calc goal seek to take very long? [closed]

Please refine "Search" in Calc - implement functions in Gnumeric [closed]

LibreOffice Calc will not link to external data via internet [closed]

Is there a LibreOffice .odt, .ods viewer for Android? [closed]

Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

Without data sheet it is hard to diagnose, but one thing to consider. Percentages are - in general - less than "1" e.g. 30% means in fact 0.30, thus, if your values in

`$P$5:$P$25`

are percentages lower than 100% your formula tries to find if-values between 4 (=400%) and 6 (=600%) and nothing (=0%) is summed. Could you upload an anonymized sample file?Thanks for reply, ill add it later on when i have more time

Q5:Q25 is the summed range containing percentages e.g 10%,20% etc. P5:P25 contains Integers. I wanted to sum the percentages in Q5:Q25 if the integers in P5:P25 were >=4 and <=6

Please also add yor OS

andLibreOffice version. So far I have checked your formula and if you have integers in column P, it works for me on:I pretty much assume that your integers are not integers but text looking like integers.