SUMIF

[Terri Deborah]

Please help!!!
When useing SUMIF how do I make my criteria blank cells?
=SUMIF(Sheet1!L4:L1003,XXXXXX,Sheet1!V4:V1003)

Terri

 

[mzehr]

Hi Terri,
Try
=SUMIF(Sheet1!L4:L1003,"",Sheet1!V4:V1003)