Counting specific criteria within a Spreadsheet

[Ben_Holmes]

I have created a large spreadsheet.

And want to count the number of times where specific entries are put in 3 different columns.

I.e. I want the number of times within the spreadsheet where the entry in column A = 1 the entry in column B = "Sheffield" and the entry in column J ="issued" .

For this to be counted all 3 inputs must be present in the same row of the spreadsheet. I have tried to use Sum Product and Count If functions but can not do it.

Does anybody have any idea how I can do this?

Kind Regards

Ben

 

[Von Pookie]

This seems to work for me:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	1	Sheffield								issued	Total:	3
2	2	Sheffield								other
3	1	other								issued
4	1	Sheffield								issued
5	1	Sheffield								issued
Sheet1

Formula used:
=SUMPRODUCT(--($A$1:$A$5=1),--($B$1:$B$5="Sheffield"),--($J$1:$J$5="issued"))

 

[Ben_Holmes]

Thanks for the help this works fine - I dont know what I was doing wrong with the sum product function as I thought I had tried this - Thanks for showing me the light.