Sumif I have no clue

[Superstar31]

Book1
	A	B	C	D	E	F
1
2
3
4	LOCATION_CODE	(All)
5
6	GROSSDEACTS			REPORT_DATE
7	NAME	EMPLOYEE_ID	WKH_DISC_REASON	9/1/2006	9/3/2006	9/4/2006
8	VariosInfo	123456	FN	4
9			JD	1
10			PG	9
11		123456		1
12	VariosInfo	234567	DF	8
13			JD	4
14		234567
15	VariosInfo	345678	PG	8
16		345678
17	VariosInfo	456789	FN	4
18			RY	6
19		456789
20		567890	QW	1
21			LH	5
22		567890
Sheet1

SO thats my data, I would like another cell to count if c8:c5000=FN and if d7=(cell location) then add number is d8:5000

does that makes sense, why can't i figure this out?

i've tried sumif and sum(if

but i give up

 

[erik.van.geit]

Hi,

this is not clear to me
especialy "if d7=(cell location)"
I suppose the formulas must be in column D ?
why do you have "4" in D8, "1" in D9, ...

kind regards,
Erik

 

[Superstar31]

Hi,

this is not clear to me
especialy "if d7=(cell location)"
I suppose the formulas must be in column D ?
why do you have "4" in D8, "1" in D9, ...

kind regards,
Erik

The numbers in column D are the amount of FN, JD for that day for that person (various info)

d7 is the date that will change ie e7 etc

 

[erik.van.geit]

not clear
please answer

I suppose the formulas must be in column D ?
why do you have "4" in D8, "1" in D9, ...

so where do you count 4 times FN ??

 

[barry houdini]

It's not very clear to me what you want to do.

It's like a sumif, sum a column of numbers based on whether column C is "FN" but the specific column to sum is determined by a date?

If that's right then with your date (e.g. 9/1/2006) in A1 try

=SUMIF(C8:C5000,"Fn",INDEX(D8:IV5000,0,MATCH(A1,D7:IV7,0)))

 

[Superstar31]

It's not very clear to me what you want to do.

It's like a sumif, sum a column of numbers based on whether column C is "FN" but the specific column to sum is determined by a date?

If that's right then with your date (e.g. 9/1/2006) in A1 try

=SUMIF(C8:C5000,"Fn",INDEX(D8:IV5000,0,MATCH(A1,D7:IV7,0)))

Hmmm, you make it sound sooo complicated. I must not be explaining properly.

But i believe you have the right idea,

Some the column if "FN" is located in the C column, however its determined by the date on row 9.

 

[barry houdini]

Sorry, I still don't get it

I don't see any date on row 9, do you mean row 7?

Where does the formula go, is it a single formula or one for each row or column?

If you just want to sum column D when column C is "FN"

=SUMIF(C8:C5000,"FN",D8:D5000)

...but I assumed it was more than that. If it is then can you give an example based on the above screenshot

 

[erik.van.geit]

Hmmm, you make it sound sooo complicated. I must not be explaining properly.

But i believe you have the right idea,

Some the column if "FN" is located in the C column, however its determined by the date on row 9.

it's impossible to find out any formula if you do not explain what it should do exactly
provide a simple-to-understand-example

1. in what cell do you put the formula (not so important)
2. where is it reading data from ? (display those data if you didn't already)
3. what is the expected result ?

 

[Superstar31]

Sorry, I still don't get it

I don't see any date on row 9, do you mean row 7?

Where does the formula go, is it a single formula or one for each row or column?

If you just want to sum column D when column C is "FN"

=SUMIF(C8:C5000,"FN",D8:D5000)

...but I assumed it was more than that. If it is then can you give an example based on the above screenshot

my apologizes, the orginal worksheet i'm using has a date of row 9, but you are correct this one has it on row 7

I have used the sumif that you just provided, but it is not calculating the data. Does it matter this is all based on access file/pivot table?

 

[Superstar31]

Neither formula seems to work?