| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula/Sum Question
If i have a dollar value in cell a1 and no value in cell a2 and the sum
formula in cell a3, a3 returns the value of cell a1 since it is the only cell with a value in it. Is there a formula that will sum a1 and a2 only when they both have values in them? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula/Sum Question
Try it this way:
=if(count(a1:a2)=2,a1+a2,"what you want when not filled in") Regards, Fred. "Jon the Contractor" <Jon the wrote in message ... If i have a dollar value in cell a1 and no value in cell a2 and the sum formula in cell a3, a3 returns the value of cell a1 since it is the only cell with a value in it. Is there a formula that will sum a1 and a2 only when they both have values in them? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula/Sum Question
Another one:
=(COUNT(A1:A2)=2)*(A1+A2) -- Biff Microsoft Excel MVP "Jon the Contractor" <Jon the wrote in message ... If i have a dollar value in cell a1 and no value in cell a2 and the sum formula in cell a3, a3 returns the value of cell a1 since it is the only cell with a value in it. Is there a formula that will sum a1 and a2 only when they both have values in them? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula question | Excel Worksheet Functions | |||
| MID formula question | Excel Worksheet Functions | |||
| Formula Question | Excel Discussion (Misc queries) | |||
| Formula Question | Excel Worksheet Functions | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
Hybrid Mode
