| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Sum across spreadsheets & ignore blanks to get rid of #VALUE!
Thanks...
"Struggling in Sheffield" wrote in message ... Hi, Thanks very much for that, yes it worked. I tried for ages to find a solution and tried SUM-ing it very early but it wouldn't work. Can only think I made some basic error when I entered the formula. Some of the formulas I was constructing after two hours were rocket science (couldn't get them to work either!). I'm sure I'll have better days..... Thanks again. "Domenic" wrote: Try simply... =SUM(July:December!A108) Hope this helps! http://www.xl-central.com In article , Struggling in Sheffield wrote: Hi, I'm trying to sum the total of the same cell in six adjacent spreadsheets (named 'July' to 'December') onto a separate summary sheet at the end. My problem is that many of the summed cells are blank which means my formula gives me a #VALUE! error. Current formula is: =SUMIF(July:December!A108,"<""") After trawling the forum for the answers to similar problems I came up with the formula above (also tried several variations) but it still returns the #VALUE! error when one or more of the summed cells is blank. In addition, if all of the summed cells are blank, it would be nice to get a blank cell or £0.00 returned in the summary cell. Thanks for looking and please help if you can. Cheers, Steve. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Median - Ignore blanks | Excel Discussion (Misc queries) | |||
| Ignore Blanks in Countifs statement | Excel Worksheet Functions | |||
| Data Validation - ignore blanks | Excel Discussion (Misc queries) | |||
| Ignore Blanks in Data Validation | Excel Worksheet Functions | |||
| USING IGNORE BLANKS IN FORMULA | Excel Discussion (Misc queries) | |||
Threaded Mode
