ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "countif" from multiple worksheets within workbook (https://www.excelbanter.com/excel-discussion-misc-queries/1683-%22countif%22-multiple-worksheets-within-workbook.html)


"countif" from multiple worksheets within workbook
 
How would I "countif" in multiple worksheet within a
workbook. Trying to total up VT time for employees Jan-
December on a summary sheet.


=sum(countif(stuff on page 1),countif(stuff on page 2))

That should do it.


-----Original Message-----
How would I "countif" in multiple worksheet within a
workbook. Trying to total up VT time for employees Jan-
December on a summary sheet.
.


Peo Sjoblom

What would the criteria be and what are the sheet names (any system or for
instance Jan-Dec)?
It is possible to count 3D with some twisting
in a single sheet how would your COUNTIF look like?


Regards,

Peo Sjoblom

" wrote:

How would I "countif" in multiple worksheet within a
workbook. Trying to total up VT time for employees Jan-
December on a summary sheet.



All times are GMT +1. The time now is 02:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com