LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 126
Default 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...

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I give text a changeable numeric value? Steve_Dallas Excel Worksheet Functions 3 October 2nd 07 11:47 PM
give text a dollar numeric value Gav Excel Worksheet Functions 6 June 5th 07 01:57 PM
Give RELEVANT responses to questions. DO NOT give usless list pmartin Excel Worksheet Functions 2 July 6th 06 06:08 PM
look between 2 cells and give the value of only 1 The-Jayhawk_fan Excel Discussion (Misc queries) 4 January 30th 06 07:42 PM
hilght cells at a give day chuck irven [email protected] Excel Worksheet Functions 1 June 27th 05 11:22 PM


All times are GMT +1. The time now is 04:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"