Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Same formula but ?value displaying
Hi all,
I made a spreadsheet and it was perfect. However, silly user didn't see it that way and removed a couple of columns she deemed unnecessary. On another worksheet I had some summary data, including 12 rows representing each month of the year, and two other columns. Each of these two columns used sumproduct to test the data in two columns on the worksheet where the user removed the columns. If various conditions were met in the corresponding two columns for the column/row on the summary worksheet, a '1' was assigned and then those were added up by month. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula result is not displaying | Excel Discussion (Misc queries) | |||
How to prevent a formula from displaying ? | Excel Discussion (Misc queries) | |||
result of formula not displaying | Excel Worksheet Functions | |||
Displaying numbers used in formula | Excel Discussion (Misc queries) | |||
displaying formula result | Excel Worksheet Functions |