=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!

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"BSantos" <(E-Mail Removed)> wrote in message
newsD668E57-46E0-4A50-9517-(E-Mail Removed)...
> =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.
>
>