Sum total from other worksheets

N

Natalie

Hello,
I have a spreadsheet that has tabs "Summary" and Overnight test results".
Under the overnight test results I have columns: date, unit, test, and test
cycles. I am using test names S4 Test and S3 Test. I want the summary sheet
to show how many total cycles the S4 test and the S3 test ran. I'm not sure
what formula I should use to get this total. TIA
Natalie
 
S

SteveG

Assuming the Overnight tab columns are in A:D

In the summary sheet

=SUMPRODUCT((C1:C1000="S4 Test")*D1:D1000)

Just change the ="S4 Test" to ="S3 Test" for that total.

or you can use SUMIF

=SUMIF(C1:C1000,"S4 Test",D1:D1000)

HTH

Steve
 
M

Marcelo

Natalie,

Try to use COUNTIF as

countif(range;creteria)

regards

Marcelo from Brazil

"Natalie" escreveu:
 
B

Bob Phillips

What does S4Test and S3Test refer to? If it is values just use

=SUMIF(Summary'!C:C,"S4Test",Summary!D:D)+SUMIF('Overnight test
results'!C:C,"S4Test",'Overnight test results'!D:D)

for S4Test

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
N

Natalie

Thank you so much Steve.
The SumIf function worked great.
These forums are so helpful!!!
 
Top