equals something
Try:
=SUMIF(G4:G74,"<",F4:F74)
"Mike" wrote:
Okay, that all makes sense, but for some reason it is not working with my
situation... tell me what you think.
this is my formula: =sumif(G4:74,"=null",F4:F74)
I've also tried: =sumif(G4:74,"<''",F4:F74)
"Toppers" wrote:
Try:
=IF(A1<"","something", "null(or empty)")
"<" means "not equal to" / "does not equal"
so above test if A1 does not equal NULL (empty) i.e. equals something
HTH
"Mike" wrote:
Okay, I know how to say "When a cell equals nothing" (="", or =0), but how
would I say "When a cell equals something", whether a letter, symbol,
number... anything?
Please help!
|