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. |
countif more than one sheet/tab and sumproduct
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. |
All times are GMT +1. The time now is 05:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com