Adding cells from two other sheets

[tinkertron]

I have three sheet where I need to total the last sheet from the previous two sheets

SHEET ONE IS CALLED "DRUG REPORT D1"
SHEET TWO IS CALLED "DRUG REPORT DRC"
SHEET THREE IS CALLED "DRUG REPORT TOTAL"

In sheet three I need to take the total in F7 from each sheet 1 and 2

I believe the formula would be?
=SUM(DRUG REPORT D1:F7+DRUG REPORT DRC:F7)

but this does not work, can someone tell me the correct formula format?

 

[kidwispa]

I have three sheet where I need to total the last sheet from the previous two sheets

SHEET ONE IS CALLED "DRUG REPORT D1"
SHEET TWO IS CALLED "DRUG REPORT DRC"
SHEET THREE IS CALLED "DRUG REPORT TOTAL"

In sheet three I need to take the total in F7 from each sheet 1 and 2

I believe the formula would be?
=SUM(DRUG REPORT D1:F7+DRUG REPORT DRC:F7)

but this does not work, can someone tell me the correct formula format?

Try

=sum('DRUG REPORT D1'!:F7)+('DRUG REPORT DRC'!F7)

 

[Jonmo1]

Try

=SUM('DRUG REPORT D1:DRUG REPORT DRC'!F7)