Microsoft Office Forums - View Single Post - SumIF with non-adjacent cells

Thread: SumIF with non-adjacent cells

View Single Post

Old

10-17-2019, 09:00 PM

kvsrinivasamurthy kvsrinivasamurthy is offline

kvsrinivasamurthy is offline

kvsrinivasamurthy uses Windows XP

Windows XP kvsrinivasamurthy uses Office 2007

kvsrinivasamurthy uses Office 2007

Office 2007

Novice

Join Date: Oct 2017

Posts: 2

kvsrinivasamurthy is on a distinguished road

Default

Try this. In P17 then copy to other cells.

=SUMIF($Y17:$AG17,Q17,$X17:$AF17)

Reply With Quote