| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Count Ifs
I have a 2 sheet work book where the cover sheet needs to show the
statistical breakdown of sheet 2. In the cover sheet I have already inserted a column which performs a €˜count if function looking for occurrences of a specific surname in the surname column A of sheet 2. 1. What formula do I need to use in the next column in my cover sheet to count if surname €˜Bloggs in Column A of sheet 2 and of these €˜bloggs also have €˜Yes in Column B of sheet 2? 2. What formula do I need to use in the next column in my cover sheet to count if surname €˜Bloggs in Column A and of these €˜bloggs also have €˜0 in Column C of sheet 2? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter Multiple Columns on Multiple Criteria and count the last co | Excel Worksheet Functions | |||
| count count multiple rows | Excel Discussion (Misc queries) | |||
| To count the data using multiple criteria in multiple columns | New Users to Excel | |||
| Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
Threaded Mode
