nataliek92
New Member
- Joined
- Oct 29, 2014
- Messages
- 40
Hello
I am currently using Excel 2010, trying to calculte a sum based on multiple if statements.
I have data similar to the following :
Month \ User ID \ Payment
8 \ 123 \ £20
8 \ 124 \ £5
9 \ 123 \ £15
9 \ 125 \ £22
9 \ 126 \ £3
I would like to count the number of new User ID's each month. In August (8), there were 2 new users. In September (9) there were also 2 new users, as User ID 123 had made a payment in August.
I know how to count the number of distinct users overall, using the following formula :
This would give the value 4.
I thought I would be able to amend this using a multiple IF statement, i.e.
But this gives the value 0, where I was expecting 2.
Basically I'm looking for a way to count the distinct User IDs in each month.
Does anyone know how to do this? Or could anyone offer any advice? It seems like it should be such a simple equation...
Thank you in advance,
Natalie
I am currently using Excel 2010, trying to calculte a sum based on multiple if statements.
I have data similar to the following :
Month \ User ID \ Payment
8 \ 123 \ £20
8 \ 124 \ £5
9 \ 123 \ £15
9 \ 125 \ £22
9 \ 126 \ £3
I would like to count the number of new User ID's each month. In August (8), there were 2 new users. In September (9) there were also 2 new users, as User ID 123 had made a payment in August.
I know how to count the number of distinct users overall, using the following formula :
Code:
=SUM(IF(FREQUENCY($B:$B,$B:$B)>0,1))
I thought I would be able to amend this using a multiple IF statement, i.e.
Code:
=SUM(IF(AND(FREQUENCY($C:$C,$C:$C)>0,$E:$E=7),1))
Basically I'm looking for a way to count the distinct User IDs in each month.
Does anyone know how to do this? Or could anyone offer any advice? It seems like it should be such a simple equation...
Thank you in advance,
Natalie