Multiple conditions

[Guest]

Column C contains 2 sets of data
Column M contains 19 sets of data

I need to write a formula that counts the all the data in column M for the
first data set in C. After which I can do the same for the second set in
column C

Thanks

thom

 

[Biff]

Need a better explanation!

Biff

 

[Guest]

Sorry, Eventually figured it out

=SUMPRODUCT(--($C$2:$C$200="A2"),--($M$2:$M$200=E$4)


Thanks Anyway