N
nc
Can I use a sumif function to sum where the criteria are blank cells? Or is
there an alternative function?
there an alternative function?
S
stew
Yes
=SUMIF(C1:C10,"",D1
10)
OR
=SUMIF(C1:C10,0,D110)
Stew
=SUMIF(C1:C10,"",D1
10)OR
=SUMIF(C1:C10,0,D1
10)Stew
M
Max
In say, C1: =SUMIF(A:A,"",B:B)
should work ok
If it returns seemingly "less", that means your data in col A contains
invisible white spaces somewhere. Clean col A up via a TRIM helper/overwrite
or do a Data > Text to Columns > Fixed Width > Finish on col A.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
should work ok
If it returns seemingly "less", that means your data in col A contains
invisible white spaces somewhere. Clean col A up via a TRIM helper/overwrite
or do a Data > Text to Columns > Fixed Width > Finish on col A.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik