| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Countif multiple worksheets
Hi,
I have two worksheets, and I want to count all the 'S' that appear from A1:H1 on each worksheet? How do I? Please help! |
|
#2
|
|||
|
|||
|
Hi Natalie
one way =COUNTIF(Sheet2!A1:H1,"S")+COUNTIF(Sheet3!A1:H1,"S ") Cheers JulieD "Natalie" wrote in message ... Hi, I have two worksheets, and I want to count all the 'S' that appear from A1:H1 on each worksheet? How do I? Please help! |
|
#3
|
|||
|
|||
|
Another way,
=SUMPRODUCT(--(COUNTIF(INDIRECT("'"&$I$1:$I$3&"'!A1:H1"),"S"))) where I1:I3 holds a list of the sheets in the workbook (extend as required). -- HTH RP (remove nothere from the email address if mailing direct) "JulieD" wrote in message ... Hi Natalie one way =COUNTIF(Sheet2!A1:H1,"S")+COUNTIF(Sheet3!A1:H1,"S ") Cheers JulieD "Natalie" wrote in message ... Hi, I have two worksheets, and I want to count all the 'S' that appear from A1:H1 on each worksheet? How do I? Please help! |
|
#4
|
|||
|
|||
|
Hi Bob
thought i would use the easy method as she said she only had two workbooks :) Cheers julieD "Bob Phillips" wrote in message ... Another way, =SUMPRODUCT(--(COUNTIF(INDIRECT("'"&$I$1:$I$3&"'!A1:H1"),"S"))) where I1:I3 holds a list of the sheets in the workbook (extend as required). -- HTH RP (remove nothere from the email address if mailing direct) "JulieD" wrote in message ... Hi Natalie one way =COUNTIF(Sheet2!A1:H1,"S")+COUNTIF(Sheet3!A1:H1,"S ") Cheers JulieD "Natalie" wrote in message ... Hi, I have two worksheets, and I want to count all the 'S' that appear from A1:H1 on each worksheet? How do I? Please help! |
|
#5
|
|||
|
|||
|
Hi Julie,
2 today, 200 tomorrow :-) Regards Bob "JulieD" wrote in message ... Hi Bob thought i would use the easy method as she said she only had two workbooks :) Cheers julieD "Bob Phillips" wrote in message ... Another way, =SUMPRODUCT(--(COUNTIF(INDIRECT("'"&$I$1:$I$3&"'!A1:H1"),"S"))) where I1:I3 holds a list of the sheets in the workbook (extend as required). -- HTH RP (remove nothere from the email address if mailing direct) "JulieD" wrote in message ... Hi Natalie one way =COUNTIF(Sheet2!A1:H1,"S")+COUNTIF(Sheet3!A1:H1,"S ") Cheers JulieD "Natalie" wrote in message ... Hi, I have two worksheets, and I want to count all the 'S' that appear from A1:H1 on each worksheet? How do I? Please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions | |||
| Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
| adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
| "countif" from multiple worksheets within workbook | Excel Discussion (Misc queries) | |||
Hybrid Mode
