Jeffers1984
New Member
- Joined
- Jan 8, 2011
- Messages
- 8
Hi everyone,
I'm a newbie to this whole Excel thing, but now I have a huge headache trying to figure this puppy out, so any help you can offer would be awesome.
I have an excel sheet with 6 tabs, all containing different data, some text and some numerical.
I need to perfect this formula to cross reference whether an email has was 'Inbound' or 'Pro-active' and if the customer was a new contact or a repeat customer.
I need to search column "D" for the word 'Inbound' on the "Emails" tab and column "E" with the letter "Y" again on the "Emails" tab
So just to clarify:
Column D only contains Text, which can only be 'Inbound' or 'Pro-Active'
Column E only contains text and that is limited to 'Y' and 'N'.
I have tried a few different formula and no luck so far.
=SUMPRODUCT((Emails!E:E="Y")*(Emails!D:D="Inbound")
=SUM(IF(Emails!D:D="Inbound",IF(E:E="Y",1,0),0))
=COUNTIF(Emails!E:E,"Y")AND COUNTIF(Emails!D:D,"Inbound”)
=SUMPRODUCT((Emails!D:D="Inbound"))*( Emails!E:E="Y")))
=SUMPRODUCT((Emails!E:E="Y")*(Emails!D:D="Inbound")
These all come back with either #VALUE! or #NUM!
Any help you can give me would be great!
I hope that all makes sense.
Thanks
Matt.
I'm a newbie to this whole Excel thing, but now I have a huge headache trying to figure this puppy out, so any help you can offer would be awesome.
I have an excel sheet with 6 tabs, all containing different data, some text and some numerical.
I need to perfect this formula to cross reference whether an email has was 'Inbound' or 'Pro-active' and if the customer was a new contact or a repeat customer.
I need to search column "D" for the word 'Inbound' on the "Emails" tab and column "E" with the letter "Y" again on the "Emails" tab
So just to clarify:
Column D only contains Text, which can only be 'Inbound' or 'Pro-Active'
Column E only contains text and that is limited to 'Y' and 'N'.
I have tried a few different formula and no luck so far.
=SUMPRODUCT((Emails!E:E="Y")*(Emails!D:D="Inbound")
=SUM(IF(Emails!D:D="Inbound",IF(E:E="Y",1,0),0))
=COUNTIF(Emails!E:E,"Y")AND COUNTIF(Emails!D:D,"Inbound”)
=SUMPRODUCT((Emails!D:D="Inbound"))*( Emails!E:E="Y")))
=SUMPRODUCT((Emails!E:E="Y")*(Emails!D:D="Inbound")
These all come back with either #VALUE! or #NUM!
Any help you can give me would be great!
I hope that all makes sense.
Thanks
Matt.