countif more than one sheet/tab and sumproduct

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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.
 
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!
 
Back
Top