Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    4
    Views
    236

    Re: getting #value! instead of total

    works a treat thank you
  2. 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. Replies
    5
    Views
    222

    Re: auto date filler

    thanks to you both works perfect thank you
  4. 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. 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. 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. Replies
    4
    Views
    149

    Re: 2 conditions for conditional fomatting

    Just had the time to try it now thank you guys it works
  8. 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. 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. Replies
    21
    Views
    1,203

    Re: if and function

    Your brilliant thank you so very much and thank you again for your help
  11. 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. 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. 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. Replies
    21
    Views
    1,203

    Re: if and function

    any other ideas? thanking you
  15. 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. 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. Replies
    21
    Views
    1,203

    Re: if and function

    Any Suggestions?
  18. 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. 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. 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. 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. 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. 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. 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. 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 2 3 4