| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif more than one sheet/tab and sumproduct
=COUNTIF((Data1!$E$3:$E$291,Data2!$E$3:$E$291,$A4) )
Can anyone help me fix my formula. I want to countif more than 1 tab. Also can you countif several tabs? Can you sumproduct more than 1 tab as well? Thanks for any help! B. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif or Sumproduct | Excel Discussion (Misc queries) | |||
| sumproduct , array or countif? | Excel Worksheet Functions | |||
| countif, sumproduct | New Users to Excel | |||
| Using COUNTIF with 2 criteria - SUMPRODUCT? | Excel Worksheet Functions | |||
| SUMPRODUCT & COUNTIF | Excel Worksheet Functions | |||
Threaded Mode
