Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |