sumifs not blank

[ajm]

i need to sumifs not blank cells. I have three blank cells in a range and i want to sum the non blanks. I have tried using "<>"" and "<>" but they do not work. What should i be using.

=SUMIFS(RAW!$R$1:$R$28869,RAW!$AM$1:$AM$28869,Sheet4!$A5,RAW!$AF$1:$AF$28869,"<>NULL",RAW!$AB$1:$AB$28869,"<>")

 

[Alex Blakenburg]

Unfortunately the SumIfs, CountIfs group of functions only excludes empty cells when trying to exclude cells that are either empty OR contain a zero length string ie "".
Filter and SumProduct (which for more recent versions of excel can be reduced to just Sum) are better options.
Try this:

=SUM(
 RAW!$R$1:$R$28869*
(RAW!$AM$1:$AM$28869=Sheet4!$A5)*
(RAW!$AF$1:$AF$28869<>"NULL")*
(RAW!$AB$1:$AB$28869<>""))

Note: If your formula is actually on Sheet4 then best practice is to remove the references to the sheet the formula is in eg $A5 not Sheet4!$A5