# SUMIFS furmula

1. ## SUMIFS furmula

Hello,
I have a table which I wish to do a SUMIFS forumula on it.
The table goes somthing like this:

A. Precent 10%
B. Precent 50%
C. Percent 12%
D. Precent 75%

For each Type I have two Categories: Grade & Precent.

i wish to have a SUMIFS forumula that sums up only the Grades which are under 15% percent (for example) - Meaning, in this tamplate = 100 (A) + 20 (C)
thanks.

2. ## Re: SUMIFS furmula

Try

=SUMIFS(A1:A4,B1:B4,"<="&15%)

3. ## Re: SUMIFS furmula

Hi atlant15

=SUMIF(criteria_range,"<0.15",sum_range)

Or do you mean Count!

4. ## Re: SUMIFS furmula

Try

=SUMIF(B2:B8,"<15%",B1:B7)

5. ## Re: SUMIFS furmula

Hi,

it doesn't work because the problem is that the numbers (which i want to sum) are above the %, meaning i cannot have 0.15 as the only crateria.

Maybe it's not understood but the type (A.. B... C... D...) is in culumn A, the 'Grade' and 'Percent' are in culumn B, and the actual numbers and % are in Culumn C.

6. ## Re: SUMIFS furmula

Just adjust my formula to the other columns.

7. ## Re: SUMIFS furmula

still doesn't work

8. ## Re: SUMIFS furmula

Does this work for you?

9. ## Re: SUMIFS furmula

Hi atlant15

Do you mean like the attached!

10. ## Re: SUMIFS furmula

Great... thank you,

i'll make it a bit harder though, what if i had another % Row in every Type (A... B...) that caculates something else, but i still would want the 15% from the 'percent' category.
something like this:

A. Percent 10%
A. Percent #2 25%
B. ....

11. ## Re: SUMIFS furmula

What would be best, post a sample workbook with your exact requirements and the expected results.

12. ## Re: SUMIFS furmula

Originally Posted by jeffreybrown
What would be best, post a sample workbook with your exact requirements and the expected results.
you are right;
it kind of grew more during the night....
attached with explenation for what i look for

13. ## Re: SUMIFS furmula

=IF(D4<15%,D2,0)+IF(D10<15%,D8)

14. ## Re: SUMIFS furmula

Well, i thought about doing that, but i got tons of lists like that...
that's why i'm looking for some kind of overall forumula

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1