counting unique values across multiple worksheets

G

Gordon Walsh

I am trying to count the number of occurances for a unique value (0) in the same column/row (F12) across multiple worksheets within a workbook but cannot find a formula that works. Any help would be appreciated

Thanks in advance
 
M

M.L. Sco Scofield

As you mention the terms worksheets and workbook, I can only assume you are using Excel.

This group is for Microsoft Access.

You will find 17 Excel groups that all start with microsoft.public.excel.

You'll have much better luck asking your Excel questions in one of those groups.

Good luck.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #16 of 19: 2 monograms = 1 diagram
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

Gordon Walsh said:
I am trying to count the number of occurances for a unique value (0) in the same column/row (F12) across multiple worksheets
within a workbook but cannot find a formula that works. Any help would be appreciated.
 
Top