Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count through tabs
Hi all,
I have a document that has 12 tabs,named after the months of the year. Could anybody tell me how to create the following equations: * COUNTIF column A in January tab +column A in February tab +column A in March tab +column A in May tab +column A in June tab +column A in July tab +column A in August tab +column A in September tab +column A in October tab +column A in November tab +column A in December tab = "Peter" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count through tabs
I assume you *accidently* left out APRIL.
Anyway ... you'll have to make a datalist of your tab names. Make sure that the spelling is *exactly* as they appear in the tabs. Say you create this list in Z1 to Z12. Then try this: =SUMPRODUCT(COUNTIF(INDIRECT("'"&Z1:Z12&"'!A:A")," Peter")) Watch those apostrophes and double quotes! They're included just in case there might be spaces in the sheet names. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Pietro" wrote in message ... Hi all, I have a document that has 12 tabs,named after the months of the year. Could anybody tell me how to create the following equations: * COUNTIF column A in January tab +column A in February tab +column A in March tab +column A in May tab +column A in June tab +column A in July tab +column A in August tab +column A in September tab +column A in October tab +column A in November tab +column A in December tab = "Peter" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count through tabs
=SUMPRODUCT(COUNTIF(INDIRECT("'"&TEXT(ROW(INDIRECT ("1:12"))*30,"mmmm")&"'!A:A"),"Peter"))
TEXT(ROW(INDIRECT("1:12"))*30,"mmmm") will generate the sheet names: January February March ... December Biff "Ragdyer" wrote in message ... I assume you *accidently* left out APRIL. Anyway ... you'll have to make a datalist of your tab names. Make sure that the spelling is *exactly* as they appear in the tabs. Say you create this list in Z1 to Z12. Then try this: =SUMPRODUCT(COUNTIF(INDIRECT("'"&Z1:Z12&"'!A:A")," Peter")) Watch those apostrophes and double quotes! They're included just in case there might be spaces in the sheet names. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Pietro" wrote in message ... Hi all, I have a document that has 12 tabs,named after the months of the year. Could anybody tell me how to create the following equations: * COUNTIF column A in January tab +column A in February tab +column A in March tab +column A in May tab +column A in June tab +column A in July tab +column A in August tab +column A in September tab +column A in October tab +column A in November tab +column A in December tab = "Peter" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can i set up tabs within tabs on Excel? | Excel Worksheet Functions | |||
Page Count with Tabs | Excel Discussion (Misc queries) | |||
Is there a way to count all the worksheet tabs in an Excel speadsh | Excel Discussion (Misc queries) | |||
How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |