A
Al Mackay
Could anyone help with the following question:
Need to be able to do a countif (obviously below is only sample data,
the real data is 2000 rows+ @ the moment).
A B
1 123 Rel4
2 123 Rel4
3 123 Rel5
The countif needs to do the following, count the number of occurences
where A = 123 and the B column on the same line is equal to Rel4.
So, therefore, the result would be 2.
I thought I may be able to get this result by concatenating the data
within the formula, however my formula is obviously nowhere near there
yet.
Can anyone help with the above, if it helps I've contanined the
formula that I started on....
Many Thanks, Al ( [email protected] )
FORMULA I've messed with, but doesn't work!!:
=COUNTIF(A1:B3 ,(CONCATENATE(B2,C2,)="123Rel4"))
Need to be able to do a countif (obviously below is only sample data,
the real data is 2000 rows+ @ the moment).
A B
1 123 Rel4
2 123 Rel4
3 123 Rel5
The countif needs to do the following, count the number of occurences
where A = 123 and the B column on the same line is equal to Rel4.
So, therefore, the result would be 2.
I thought I may be able to get this result by concatenating the data
within the formula, however my formula is obviously nowhere near there
yet.
Can anyone help with the above, if it helps I've contanined the
formula that I started on....
Many Thanks, Al ( [email protected] )
FORMULA I've messed with, but doesn't work!!:
=COUNTIF(A1:B3 ,(CONCATENATE(B2,C2,)="123Rel4"))