Microsoft Office Forums - View Single Post - Using Right and Len formulas together

Thread: Using Right and Len formulas together

View Single Post

Old

11-18-2015, 09:43 AM

Kevin@Radstock Kevin@Radstock is offline

Kevin@Radstock is offline

Kevin@Radstock uses Windows 10

Windows 10 Kevin@Radstock uses Office 2016

Kevin@Radstock uses Office 2016

Office 2016

Office 365

Join Date: Feb 2012

Posts: 94

Kevin@Radstock is on a distinguished road

Default

Hi PDGood

Try the following.

=SUMPRODUCT(--(RIGHT(A1:A12,1)="A"))

Sorry missed the second part.

=SUMPRODUCT(--(RIGHT(A1:A12,1)="A"),B1:B12)

Reply With Quote