Hello,
I have a table which I wish to do a SUMIFS forumula on it.
The table goes somthing like this:
A. Grade 100
A. Precent 10%
B. Grade 80
B. Precent 50%
C. Grade 20
C. Percent 12%
D. Grade 50
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.
Bookmarks