View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default When a cell is blank, add another

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You send a clear explanation of what you want
3. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Todd Fleming" wrote in message
...
I've messed around with this for a couple hours now and can't figure
it out.

When G10 is blank on 'Worksheet 2', I'd like to add F10 from
'Worksheet 2', to F10 on 'Worksheet 3' if G10 is blank on 'Worksheet
3' as well, and so on for many worksheets within the workbook. If G10
is NOT blank on any of the worksheets, then disregard the addition of
that particular G10 cell in the formula. I'd like the totals to go
into cell H4 on 'Worksheet A'.

Thanks! (I think I may be more confused now than when I started)

Todd