Microsoft Office Forums - View Single Post - [Solved] Sum scattered data with same label

Thread: [Solved] Sum scattered data with same label

View Single Post

Old

12-28-2016, 01:40 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Try in K13 and copied down...

=SUMIF(A:G,J13,B:H)

Reply With Quote