# Search:

Type: Posts; User: Patcheen; Keyword(s):

Page 1 of 6 1

1. ## Thread: getting #value! instead of total

by Patcheen
Replies
4
Views
236

### Re: getting #value! instead of total

works a treat thank you
2. ## Thread: getting #value! instead of total

by Patcheen
Replies
4
Views
236

### getting #value! instead of total

when i paste this i get #value!

=SUM(IF('Shirt Database'!A2:A500,'Goal Keeper List'!B61,SUMIF('Shirt Database'!\$F\$2:\$F\$500,{"sub on","sub off","started","injured"},'Shirt Database'!\$K\$2:\$K\$500)))...
3. ## Thread: auto date filler

by Patcheen
Replies
5
Views
222

### Re: auto date filler

thanks to you both works perfect thank you
4. ## Thread: auto date filler

by Patcheen
Replies
5
Views
222

### auto date filler

ive a workbook that the days never change

in A2 i have 10/09/15 (Saturday) and in A3 i have 09/09/15 (Wednesday)

in A4 i have 12/09/15 (Saturday) and in A4 i have 16/09/15 (Wednesday)

so on...
5. ## Thread: adding more to formula

by Patcheen
Replies
5
Views
313

### Re: adding more to formula

thank you as i stated that works fine without this ,ROW('Match Database'!\$g\$2:\$g\$5000,"home i want to add that to it but when i do i get "you have entered too many arguments for this function......"
6. ## Thread: adding more to formula

by Patcheen
Replies
5
Views
313

### adding more to formula

this formula works perfect until i add more to it
=MAX(FREQUENCY(IF(ISNUMBER(MATCH('Match Database'!\$H\$2:\$H\$5000,{"Won","Drew"},0)),ROW('Match Database'!\$H\$2:\$H\$5000)),IF('Match...
7. ## Thread: 2 conditions for conditional fomatting

by Patcheen
Replies
4
Views
149

### Re: 2 conditions for conditional fomatting

Just had the time to try it now thank you guys it works
8. ## Thread: 2 conditions for conditional fomatting

by Patcheen
Replies
4
Views
149

### 2 conditions for conditional fomatting

i am trying to use this formula for conditional formatting but its not working

=(\$B3="Henry,\$i3="Harry")

My data in is columsns B3 to I200

Column B And coulmn I are names
9. ## Thread: if and function

by Patcheen
Replies
21
Views
1,203

### Re: if and function

you are a super star thank you so very much it is brill thank you it works perfectly dont know how you thought of all that but id love to know thank you so very very much again for you help and time...
10. ## Thread: if and function

by Patcheen
Replies
21
Views
1,203

### Re: if and function

Your brilliant thank you so very much and thank you again for your help
11. ## Thread: if and function

by Patcheen
Replies
21
Views
1,203

### Re: if and function

it works a treat thank you for your help but ive only the one fixture list i showed two for sample so you could see the idea i was getting at...

is it possible to get them combined ill understand...
12. ## Thread: Remove everything after the ?

by Patcheen
Replies
7
Views
138

### Re: Remove everything after the ?

can u right click it and copy and paste in the cell you want it in excel
13. ## Thread: Remove everything after the ?

by Patcheen
Replies
7
Views
138

### Re: Remove everything after the ?

any good ? https://www.walmart.com/ip/Play-Doh-*******-Creations-Sizzlin-Stovetop-Food-Set/172270905
14. ## Thread: if and function

by Patcheen
Replies
21
Views
1,203

### Re: if and function

any other ideas? thanking you
15. ## Thread: if and function

by Patcheen
Replies
21
Views
1,203

### Re: if and function

what im trying to achieve is that when the conditions match it give me the away team thats playing Bandon in d6 (populated from the fixture data sheet) answer in G6 is Milford data gotten from...
16. ## Thread: if and function

by Patcheen
Replies
21
Views
1,203

### Re: if and function

If game number, Game date and team in J1 (in example workbook) match then it should return answer Milford thats in the i4 in the fixture data sheet. i need to be able drag it down.

if i got...
17. ## Thread: if and function

by Patcheen
Replies
21
Views
1,203

### Re: if and function

Any Suggestions?
18. ## Thread: if and function

by Patcheen
Replies
21
Views
1,203

### Re: if and function

hope somehow this sample workbook helps this is dropbox link https://www.dropbox.com/s/096c10kqlhkjq06/Sample.xlsx?dl=0
19. ## Thread: if and function

by Patcheen
Replies
21
Views
1,203

### Re: if and function

If all these are met '=IF(AND('Fixtures and Results'!A4=local!A6,'Fixtures and Results'!c4=local!b6),'Fixtures and Results'!F4,local!A101) then it returns the answer from I4 i know it only does the...
20. ## Thread: if and function

by Patcheen
Replies
21
Views
1,203

### Re: if and function

the one that excel has the prob wit as it were or would i need a totally different formula
21. ## Thread: if and function

by Patcheen
Replies
21
Views
1,203

### Re: if and function

i totally understand what ye are saying so is there anyway to include the extra condition?
22. ## Thread: if and function

by Patcheen
Replies
21
Views
1,203

### if and function

im using this formula to give me whats in fixtures and results I4 but it says

You've entered too many arguments for this function

=IF(AND('Fixtures and Results'!A4=local!A6,'Fixtures and...
23. ## Thread: Sumif condition

by Patcheen
Replies
2
Views
171

### Re: Sumif condition

Yep good spot AboyNC i just spotted that too thank you and sorry everyone for putting up wrong info
24. ## Thread: Sumif condition

by Patcheen
Replies
2
Views
171

### Sumif condition

My formula is
=SUMIF(B6:B93,A101,L6:L93)

the condition im looking for is if B6:B93 =B101 then add the numbers from L6:L93 together

but when i do its giving me 0 instead of 1

i surely cant...
25. ## Thread: Returning zero instead of total

by Patcheen
Replies
2
Views
121

### Re: Returning zero instead of total

Perfect thank you........ur brill
Results 1 to 25 of 150
Page 1 of 6 1