Natalie,

Try to use COUNTIF as

countif(range;creteria)

regards

Marcelo from Brazil

"Natalie" escreveu:

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