Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HOw do I add fields between worksheets?
I am working on license inventory. Each sheet is a computer with software
listed. I'm currently using a COUNTIF statement but how do I get the COUNTIF to span across 2 or more worksheets to give me a total of the software installed on all the computers? |
#2
|
|||
|
|||
Hi
provide some more details: - how are the sheets named - what column do you want to count -- Regards Frank Kabel Frankfurt, Germany "Excel Monkey Boy" <Excel Monkey schrieb im Newsbeitrag ... I am working on license inventory. Each sheet is a computer with software listed. I'm currently using a COUNTIF statement but how do I get the COUNTIF to span across 2 or more worksheets to give me a total of the software installed on all the computers? |
#3
|
|||
|
|||
The sheets are named by a person's name. Example: Joe, John
The columns I want to count are operating systems. Example: XP Professional, Windows 2000 Professional, etc. "Frank Kabel" wrote: Hi provide some more details: - how are the sheets named - what column do you want to count -- Regards Frank Kabel Frankfurt, Germany "Excel Monkey Boy" <Excel Monkey schrieb im Newsbeitrag ... I am working on license inventory. Each sheet is a computer with software listed. I'm currently using a COUNTIF statement but how do I get the COUNTIF to span across 2 or more worksheets to give me a total of the software installed on all the computers? |
#4
|
|||
|
|||
Sheets are named by user. Example: Bob, John, Sarah
Columns I want to count are BobA3, JohnA3, SarahA2 The columns have different Operating systems in them such as: XP Professional, and Windows 2000 Professional. "Frank Kabel" wrote: Hi provide some more details: - how are the sheets named - what column do you want to count -- Regards Frank Kabel Frankfurt, Germany "Excel Monkey Boy" <Excel Monkey schrieb im Newsbeitrag ... I am working on license inventory. Each sheet is a computer with software listed. I'm currently using a COUNTIF statement but how do I get the COUNTIF to span across 2 or more worksheets to give me a total of the software installed on all the computers? |
#5
|
|||
|
|||
Hi
1. On your summary sheet create a list with your worksheet names. e.g. put them in the range X1:X3 2. try the following formula to count all occurences of the string 'software1' in the range A1:A100 on each of these sheets =SUMPRODUCT(COUNTIF(INDIRECT("'" & X1:X3 & "'!A1:A100),"software1")) -- Regards Frank Kabel Frankfurt, Germany "Frank Kabel" schrieb im Newsbeitrag ... Hi provide some more details: - how are the sheets named - what column do you want to count -- Regards Frank Kabel Frankfurt, Germany "Excel Monkey Boy" <Excel Monkey schrieb im Newsbeitrag ... I am working on license inventory. Each sheet is a computer with software listed. I'm currently using a COUNTIF statement but how do I get the COUNTIF to span across 2 or more worksheets to give me a total of the software installed on all the computers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Spreadsheet with Merged Fields | Excel Discussion (Misc queries) | |||
Number of worksheets | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
filter on color-filled fields | Excel Worksheet Functions | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |