Dear Mr/Mrs Expert, I would like to explain that L3:L51 is my sum range. How to combine the two range as below? Hope there is some expert to help me out. Thank you SUMIF(S3:S51,"",L3:L51) SUMIF(W3:W51,"",L3:L51)