Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# EXCEL FUNCTION

Posted on 2014-10-29
Medium Priority
138 Views
I have applied the ate attached function which is simply to apply sumifs to those cells in a column that meet a condition obtained by applying the RIGHT function to the cells in the column.
However all that comes back is a value of 0 .
What have I done incorrectlySUMIFS-WITH-RIGHT.xlsx

SUMIFS(B3:B9,A3:A9,RIGHT(A3:A9,6)="EXTELP")
0
Question by:DAVID131

LVL 12

Expert Comment

ID: 40411645
You might need an additional column for this.
If you use an extra column C and in C3 the following formula:
=RIGHT(A3,6)
and then copy this formula down to C9. Then change the formula in B11 to:
SUMIFS(B3:B9,C3:C9,"EXTELP")
0

LVL 23

Accepted Solution

Ejgil Hedegaard earned 2000 total points
ID: 40411774
Use an array formula
=SUM(IF(RIGHT(A3:A9,6)="EXTELP",B3:B9,0))
Insert in cell with Ctrl+Shift+Enter, and Excel enclose the formula in {} brackets.

or use Sumproduct
=SUMPRODUCT(--(RIGHT(A3:A9,6)="EXTELP"),B3:B9)
0

Author Closing Comment

ID: 40414211
I have opted for this solution as I did not want to add another column
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With the internet and the ease of information transference, many professional jobs can be done anywhere today.  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified?   Outso…
Gain an elementary understanding of Blockchain technology.
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
###### Suggested Courses
Course of the Month8 days, 2 hours left to enroll