M

#### MikeG

If instead I replace the criteria "<>" with "=" and use the formula SUMIF(B1:B8,"=",A1:A8), I sum the numbers in column A that have correspondingblank cells. This also works with COUNTIF(A1:A8,"<>") and COUNTIF(A1:A8,"=") by either eliminating blank cells with "<>" or eliminating numbers and text with "=", thus giving the same results as COUNTA(B1:B8) or COUNTBLANK(B1:B8) respectively would.

I cannot find any built in substitutions for the =SUMIF example that I brought up first that would achieve similar results as COUNTA & COUNTBLANK do..

Why does "<>" disregard the blank cells and "=" disregard the numbers andtext?