Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf should work across sheets
The formula =COUNT(Sheet2:Sheet6!A1) works fine,
as does the formula =COUNTIF(A1:A6,"<4") but the formula =COUNTIF(Sheet2:Sheet6!A1,"<4") does not. If there anyway of counting across sheets only when a particular condition applys? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...et.f unctions |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf should work across sheets
=SUMPRODUCT(COUNTIF(INDIRECT("'Sheet"&{1,2,3,4,5,6 }&"'!A1"),"<4"))
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) " om wrote in message ... The formula =COUNT(Sheet2:Sheet6!A1) works fine, as does the formula =COUNTIF(A1:A6,"<4") but the formula =COUNTIF(Sheet2:Sheet6!A1,"<4") does not. If there anyway of counting across sheets only when a particular condition applys? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...id=2cb14e2c-b5 67-4936-ad4e-178a2a427211&dg=microsoft.public.excel.worksheet.f unctions |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CountIf should work across sheets
excuse me Bob....Mr thinker thats a good one...but please dont delete any
sheet in that range or even rename the sheet...good luck...more power Bob n Thinker "Bob Phillips" wrote: =SUMPRODUCT(COUNTIF(INDIRECT("'Sheet"&{1,2,3,4,5,6 }&"'!A1"),"<4")) -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) " om wrote in message ... The formula =COUNT(Sheet2:Sheet6!A1) works fine, as does the formula =COUNTIF(A1:A6,"<4") but the formula =COUNTIF(Sheet2:Sheet6!A1,"<4") does not. If there anyway of counting across sheets only when a particular condition applys? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/comm...id=2cb14e2c-b5 67-4936-ad4e-178a2a427211&dg=microsoft.public.excel.worksheet.f unctions |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Switch between different work sheets Randomly | Excel Discussion (Misc queries) | |||
Please help!! Countif formula doesnn't work with text format | Excel Discussion (Misc queries) | |||
validate work sheets | Excel Worksheet Functions | |||
deleted work sheets - Excel | Excel Worksheet Functions | |||
church expenses, income work sheets | Excel Discussion (Misc queries) |