software

=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

quot;BSantosquot; gt; wrote in message
news
gt; =COUNTIF((Data1!$E$3:$E$291,Data2!$E$3:$E$291,$A4) )
gt;
gt; Can anyone help me fix my formula. I want to countif more than 1 tab. Also
gt; can you countif several tabs?
gt;
gt; Can you sumproduct more than 1 tab as well?
gt;
gt; Thanks for any help! B.
gt;
gt;