| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate total number of items that meet 2 over multiple sheets
I have several sheets setup from which I need to caluculate: how many of the
cells in a range meet both criteria. It's setup something like the below: A B C D E F.... 1 y y n n y y 2 n y n y y n I need to determine how many "y" in range A1:F1 that are also "y" in A2:F2 across multiple sheets. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summary Sheet - Total Multiple Sheets | Excel Discussion (Misc queries) | |||
| How do I get the total number of items that meet 2 criteria in Exc | Excel Worksheet Functions | |||
| HOW TO CALCULATE 2/10 OF 1 PERCENT OF A TOTAL NUMBER? | Excel Worksheet Functions | |||
| running total from the same field on multiple sheets as i add she | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Threaded Mode
