When a cell is blank, add another

  • Thread starter Thread starter Todd Fleming
  • Start date Start date
T

Todd Fleming

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
 
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.
 
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")))
 
Back
Top