DAVID131
asked on
EXCEL FUNCTION
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(A 3:A9,6)="E XTELP")
However all that comes back is a value of 0 .
What have I done incorrectlySUMIFS-WITH-RIGHT.xlsx
SUMIFS(B3:B9,A3:A9,RIGHT(A
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have opted for this solution as I did not want to add another column
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