SUMIF with non-adjancent cells
I want to sum from cells C5,G5,K5,O5,.....,AI5
only the ones with positive values.
Try this:
=SUMPRODUCT(--(MOD(COLUMN(C5:AI5)+1,4)=0),--(C5:AI50),C5:AI5)
--
Biff
Microsoft Excel MVP
"ismae" wrote in message
...
Hi. Anyone knows how to use ranges of non-adjacent cells in a SUMIF
function?
|