G

#### Guest

I'm stuck.

I have multiple worksheets where I need to sum the data in the column if the

top cell contains a specific value on each worksheet. I found where I can do

a 3D sum but it doesn't allow the conditional "if"

For example:

Sheet1 Sheet2

Sheet3 etc....

A1=Yes D1=No A1=blank D1= No A1=No D1=Yes

A2=14 D2=3 A2=3 D2=5 A2=3 D2=15

A3=10 D3=15 A3=19 D3=1 A3=1 D3=11

A4=7 D4=1 A4=5 D4=22 A4=10 D4=30

Sum A2:A55 on all worksheets containing "Yes" in A1.

Sum D255 on all worksheets containing "No" in D1.

It's not always "yes" or "No". There are a few cell 1 values I would target.

Can anyone help me with this?

Thanks,