=sumif(july!i2:i150,july!i2:i150>july!j2:j150,july!i2:i150)
the above statement should return total of paid expenses in july!j2:j150 when budgeted expenses (july!i2:i150) greater paid expenses (july!j2:j150).
instead 0 total. there several thousand dollars budget , paid ranges.... no amount of changes seem make difference.
help please... spent hours on this.
thanks all
jb
as array formula (use ctrl+shift+enter) instead of enter:
{=sum(if(july!i2:i150>july!j2:j150,july!j2:j150))}
Office / Excel / Windows 10 / Office 2016
Comments
Post a Comment