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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif more than one sheet/tab and sumproduct
To count how many times the value in A4 is found on either sheet in the
ranges E3:E291 =COUNTIF(Data1!$E$3:$E$291,$A4) + COUNTIF(Data2!$E$3:$E$291,$A4)) OR =SUMPRODUCT( --(Data1!$E$3:$E$291=$A4))+SUMPRODUCT( --(Data1!$E$3:$E$291=$A4)) Or do you want to know if a specific cell on BOTH sheets equal A4 =SUMPRODUCT( --(Data1!$E$3:$E$291=$A4),--(Data1!$E$3:$E$291=$A4)) Please: they are SHEETS that get opened by clicking TABS Know the right terms if you want to make use of Help! -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "BSantos" wrote in message ... =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. |
Reply |
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 |