Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
Is there a way of adding blank cells and without getting a result of 0
E.g. =sum(A1+B2) Answer is 0 is there a way of just have a blank cell Cells A1 and B2 are blank ---------------------------------------- All this to make conditional formatting to work:- Blank cell = no colour 0 = Green 1 = Yellow Between 2 and 999 = Red Hope you can help Regards |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
Try this:
=IF(AND(A1="",B1=""),"",A1+B1) Hope this helps. Pete On Jan 26, 10:36*am, "Stig - tame racing driver" <Derek- wrote: Is there a way of adding blank cells and without getting a result of 0 E.g. =sum(A1+B2) * *Answer is 0 is there a way of just have a blank cell Cells A1 and B2 are blank ---------------------------------------- All this to make conditional formatting to work:- Blank cell = no colour 0 = Green 1 = Yellow Between 2 and 999 = Red Hope you can help Regards |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
For a start, you don't need the SUM function if you are not asking it to sum
two or more arguments. You can use either SUM(A1,B2) or just =A1+B2. To deal with blank inputs, you could use =IF(COUNT(A1,B2)=2,A1+B2,"") if you want both inputs to be non-blank, or =IF(COUNT(A1,B2)=0,"",A1+B2) if you want either to be non-blank. -- David Biddulph "Stig - tame racing driver" wrote in message ... Is there a way of adding blank cells and without getting a result of 0 E.g. =sum(A1+B2) Answer is 0 is there a way of just have a blank cell Cells A1 and B2 are blank ---------------------------------------- All this to make conditional formatting to work:- Blank cell = no colour 0 = Green 1 = Yellow Between 2 and 999 = Red Hope you can help Regards |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
Thanks again.... problem solved
"Pete_UK" wrote in message ... Try this: =IF(AND(A1="",B1=""),"",A1+B1) Hope this helps. Pete On Jan 26, 10:36 am, "Stig - tame racing driver" <Derek- wrote: Is there a way of adding blank cells and without getting a result of 0 E.g. =sum(A1+B2) Answer is 0 is there a way of just have a blank cell Cells A1 and B2 are blank ---------------------------------------- All this to make conditional formatting to work:- Blank cell = no colour 0 = Green 1 = Yellow Between 2 and 999 = Red Hope you can help Regards |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count
You're welcome, Stig.
Keep racing. Pete On Jan 26, 11:09*am, "Stig - tame racing driver" <Derek- wrote: Thanks again.... problem solved |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |