Hello guys, I have question for my following issue:
I'm trying to figure out the amount of emails registered from each email domain by month, the information I have is Column A the dates of creating (for example(01/01/13))
and in column B I the emails ex (john@gmail.com, richard@hotmail.com, kitcat@gmail.com, etc), this is the COUNTIFS I've been trying: =COUNTIFS($P$6:$Q$9, F$8, L8:L11, K8) where $P$6:$Q$9, is an extra table I made for detaching the email handle from the domain which goes something like this: =RIGHT(C3,LEN(C3)-FIND("@",C3)) and L8:L11 corr to an extra month table that I also made it goes something like =MONTH(A#) . Whoever I'm getting a value error with =COUNTIFS($P$6:$Q$9, F$8, L8:L11, K8) , without the second criteria I get results but only by edom and doesn't take in consideration the months.
Any tips? Thank you guys!
I'm trying to figure out the amount of emails registered from each email domain by month, the information I have is Column A the dates of creating (for example(01/01/13))
and in column B I the emails ex (john@gmail.com, richard@hotmail.com, kitcat@gmail.com, etc), this is the COUNTIFS I've been trying: =COUNTIFS($P$6:$Q$9, F$8, L8:L11, K8) where $P$6:$Q$9, is an extra table I made for detaching the email handle from the domain which goes something like this: =RIGHT(C3,LEN(C3)-FIND("@",C3)) and L8:L11 corr to an extra month table that I also made it goes something like =MONTH(A#) . Whoever I'm getting a value error with =COUNTIFS($P$6:$Q$9, F$8, L8:L11, K8) , without the second criteria I get results but only by edom and doesn't take in consideration the months.
Any tips? Thank you guys!