Problem counting records

[heimdaloz]

Hi, I have a excel data set that contains the following:

Position | 1 Feb | 2 Feb | 3 Feb |
------------------------------------------
Position 1 | A | A | C |
Position 2 | B | A | D |
Position 1 | D | A | C |

So the data represents the projects (A, B, C, D) that different people work during the month of February.

The sheet counts the number of Days spent on each project using Countif. For exam Project A = 4

I have had a request to be about to give the number of days spent on a project by position. For example Position 1 - Project A = 3

I started out trying to using an AND but don't know how to deal with the fact I only want to to Count the cells on certain rows.

I am current using Excel 2013, but if this is not possible, maybe able to use Excel 365.

 

[Peter_SSs]

I am current using Excel 2013, but if this is not possible, maybe able to use Excel 365.

I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I also suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

See if this helps

20 04 29.xlsm
	A	B	C	D	E	F	G	H
1	Position	1-Feb	2-Feb	3-Feb		Position	Project	Count
2	Position 1	A	A	C		Position 1	A	3
3	Position 2	B	A	D
4	Position 1	D	A	C
SP

Cell Formulas
Range	Formula
H2	H2	=SUMPRODUCT((B2:D4=G2)*(A2:A4=F2))

 

[heimdaloz]

Hi Peter,
Sorry for the delay in getting back. This is exactly what I needed and thanks for the tip on XL2BB.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.