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