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.