function to check for entry

K

kaplonk

I'll try and make this as clear as I can...

I am looking for a function that will check column b,c,d,e for an entr
if there is an entry then check row n in the same row for it's value.

that's the first bit, then I need to be able to check the date valu
(month) in column a and total it for the month.

perhaps I could run the first function only looking for month=1 o
something and just run it 12 times?

not sure how to go about this
 
K

kaplonk

well I've got this far but it still doesn't work and gives an error:

=IF(MONTH(A3:A167)=4,IF(B3:B167>0,SUM(O3:O167)), 0)

what I am trying to make it say is:

search through B3:B167 if there is an entry check if the month is apri
and there a value in the corresponding cell in column O.
I want to get the sum of column O that fit the criterior define
above.

I'm propbably miles away from it with that function
 
K

kaplonk

this does what I want but only in one line:
=IF(MONTH(A30)=4,IF((B30>0),O30,0), 0)

I want to be able to check instead of the individual cell, the arra
3:16
 
K

kaplonk

a rough sample of possible variables.

___A______B__ C________
1] 21/4/04 100 17.5
2] 28/4/04
3] 27/5/04 200 35
4] 17/4/04 50
5] 14/4/04 15
6] 13/2/04 100 17.5
7] 16/4/04 100 17.5
8] 29/7/04 7
 
K

kaplonk

a rough sample of possible variables.

___A______B__ C________
1] 21/4/04 100 17.5
2] 28/4/04
3] 27/5/04 200 35
4] 17/4/04 50
5] 14/4/04 15
6] 13/2/04 100 17.5
7] 16/4/04 100 17.5
8] 29/7/04 75
 
K

kaplonk

a rough sample of possible variables.

___A______B__ C________
1] 21/4/04 100 17.5
2] 28/4/04
3] 27/5/04 200 35
4] 17/4/04 50
5] 14/4/04 15
6] 13/2/04 100 17.5
7] 16/4/04 100 17.5
8] 29/7/04 7
 
K

kaplonk

a rough sample of possible variables.

___A______B__ C________
1] 21/4/04 100 17.5
2] 28/4/04
3] 27/5/04 200 35
4] 17/4/04 50
5] 14/4/04 15
6] 13/2/04 100 17.5
7] 16/4/04 100 17.5
8] 29/7/04 7
 
K

kaplonk

a rough sample of possible variables.

___A______B__ C________
1] 21/4/04 100 17.5
2] 28/4/04
3] 27/5/04 200 35
4] 17/4/04 50
5] 14/4/04 15
6] 13/2/04 100 17.5
7] 16/4/04 100 17.5
8] 29/7/04 7
 
K

kaplonk

a rough sample of possible variables.

___A______B__ C________
1] 21/4/04 100 17.5
2] 28/4/04
3] 27/5/04 200 35
4] 17/4/04 50
5] 14/4/04 15
6] 13/2/04 100 17.5
7] 16/4/04 100 17.5
8] 29/7/04 7
 
T

theillknight

There's probably a better answer, but one solution can be to create
column (say, column P) that references column A with the functio
month().

Then, you can just do:

=sumif(column P, 4, column B)

then repeat it for each column that you're interested in and for eac
month.

By the way, I'm having problems using month() for the dd/mm/yyy
format. Does it work for you
 
Top