View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BSantos
 
Posts: n/a
Default 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.