When a cell is blank, add another
 

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

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

When a cell is blank, add another
 

OK, so in a worksheet, you'll need to type the names of all your sheets in a
column, then highlight the column.

once highlighted, enter "names" (without the quotes) in that box to the left
of the formula bar (where the current cell names shows up)

Then, enter the below formula in A4 of worksheet A

=SUMPRODUCT(SUMIF(INDIRECT(names&"!$g$10:$g$10")," ",INDIRECT(names&"!f$10:f$10")))

"Todd Fleming" wrote:

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