Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I give up, trying to sum with non numeric cells.
I give up... a simples sum is turning out to be too much for me...
I have six sheets named by the weekdays (monday to saturday) On cel E1 I have the day and month jun-16 On cell C68 I have a formula that either returns a number or "" (empty) I am trying to sum the C68 cells of the six sheets only if the month of each sheet matches current month (month(monday!E1)=6 for ie. If one of the C68 cell is empty ("") then I get a #value error and I cant seem to convert it to zero. I know it is simple but I cant find the solution. Please help... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I give up, trying to sum with non numeric cells.
The easiest way to do this would be to use another cell on each sheet (the
same cell) that tests the month number. =IF(MONTH(NOW())=MONTH(E1),C68,"") You can group the sheets together and enter the formula on one sheet and it will be entered on all the grouped sheets automatically. Just remember to ungroup the sheets when your done! Then use a sum formula for all of those cells. Assume you enter the above formula on each sheet in cell A1. =SUM(Monday:Saturday!A1) -- Biff Microsoft Excel MVP wrote in message ... I give up... a simples sum is turning out to be too much for me... I have six sheets named by the weekdays (monday to saturday) On cel E1 I have the day and month jun-16 On cell C68 I have a formula that either returns a number or "" (empty) I am trying to sum the C68 cells of the six sheets only if the month of each sheet matches current month (month(monday!E1)=6 for ie. If one of the C68 cell is empty ("") then I get a #value error and I cant seem to convert it to zero. I know it is simple but I cant find the solution. Please help... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I give up, trying to sum with non numeric cells.
In each cell C68, return 0 rather than "" - you can then go to format
cells/number and choose "custom", and enter this: #;-#;; as the number format. Sam " wrote: I give up... a simples sum is turning out to be too much for me... I have six sheets named by the weekdays (monday to saturday) On cel E1 I have the day and month jun-16 On cell C68 I have a formula that either returns a number or "" (empty) I am trying to sum the C68 cells of the six sheets only if the month of each sheet matches current month (month(monday!E1)=6 for ie. If one of the C68 cell is empty ("") then I get a #value error and I cant seem to convert it to zero. I know it is simple but I cant find the solution. Please help... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I give text a changeable numeric value? | Excel Worksheet Functions | |||
give text a dollar numeric value | Excel Worksheet Functions | |||
Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
look between 2 cells and give the value of only 1 | Excel Discussion (Misc queries) | |||
hilght cells at a give day | Excel Worksheet Functions |