LinkBack URL
About LinkBacks
How can I make the following code say...if returning a 0, then " "
I dont want a screen full of 0's, would rather have empty cells?
=SUMIF($M$2:$M$32,B$1&Attendance!$A2,$D$2:$D$32)
How can I make the following code say...if returning a 0, then " "
I dont want a screen full of 0's, would rather have empty cells?
=SUMIF($M$2:$M$32,B$1&Attendance!$A2,$D$2:$D$32)
=If(SUMIF($M$2:$M$32,B$1&Attendance!$A2,$D$2:$D$32)=0,"",SUMIF($M$2:$M$32,B$1&Attendance!$A2,$D$2:$D$32))
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Or you could just tell Excel (in the options) to not show zeros for that sheet.
Or you could use Conditional Format to apply a white font if cell = 0.
i tried this formula, but I forgot the "=0" part...go figure,Originally Posted by MarvinP
=If(SUMIF($M$2:$M$32,B$1&Attendance!$A2,$D$2:$D$32)=0,"",SUMIF($M$2:$M$32,B$1&Attendance!$A2,$D$2:$D$32))
Thanks Marvin
Other good ideas, will remember those, thanks Cutter!
Last edited by Staci; 03-08-2011 at 08:11 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks