Hi all
Yesterday I wrote one hell of a long IF-statement (the whole statement falls in the range or A1:U31 with font size set to 11) and only after that I read about the Do-Until Loop. However, I am still not sure how to use this function.
The criteria as as follows:
- IF(AND(S12=DATE(2012,1,1),S14="VIP",S16="LS"),SUMIFS(AC:AC,Y:Y,DATE(2012,1,1),AA:AA,"VIP",AB:AB,"LS") OR
- IF(AND(S12=DATE(2012,1,1),S14="Life",S16="LS"),SUMIFS(AC:AC,Y:Y,DATE(2012,1,1),AA:AA,"Life",AB:AB,"LS") OR
- IF(AND(S12=DATE(2012,1,1),S14="VIP",S16="PR"),SUMIFS(AC:AC,Y:Y,DATE(2012,1,1),AA:AA,"VIP",AB:AB,"PR") OR
- IF(AND(S12=DATE(2012,1,1),S14="Life",S16="PR"),SUMIFS(AC:AC,Y:Y,DATE(2012,1,1),AA:AA,"Life",AB:AB,"PR") OR
- IF(AND(S12=DATE(2012,1,1),S14="RA",S16="LS"),SUMIFS(AC:AC,Y:Y,DATE(2012,1,1),AA:AA,"RA",AB:AB,"LS")
The above are the search criteria for January -- I need the loop to do the search for the whole year (i.e. January to December).
I will really appreciate any help and/or advice.
Thanks guys!
Cheers
Bookmarks