Microsoft Office Forums - View Single Post - Picture attached. Need one column to return sum of another column.

Thread: Picture attached. Need one column to return sum of another column.

View Single Post

Old

11-17-2017, 10:57 AM

IRHSAM

IRHSAM is offline

IRHSAM uses Windows 10

Windows 10 IRHSAM uses Office 2013

IRHSAM uses Office 2013

Office 2013

Novice

The original poster

Join Date: Nov 2017

Posts: 4

IRHSAM is on a distinguished road

Default

=SUMIFS(P7:P18,P6,Q7:Q18)

worked! thanks! I don't know why I was hung up on SUMPRODUCT!

edit: corrected the formula

Reply With Quote