+ Reply to Thread
Results 1 to 18 of 18

VBA loops

Hybrid View

Malowle VBA loops 08-01-2012, 06:50 PM
Cutter Re: VBA loops 08-01-2012, 07:17 PM
rylo Re: VBA loops 08-01-2012, 07:27 PM
TMS Re: VBA loops 08-01-2012, 07:37 PM
mikerickson Re: VBA loops 08-01-2012, 08:11 PM
Malowle Re: VBA loops 08-02-2012, 04:05 AM
TMS Re: VBA loops 08-02-2012, 04:16 AM
Malowle Re: VBA loops 08-02-2012, 04:40 AM
TMS Re: VBA loops 08-02-2012, 04:43 AM
Malowle Re: VBA loops 08-02-2012, 05:00 AM
TMS Re: VBA loops 08-02-2012, 05:49 AM
Malowle Re: VBA loops 08-02-2012, 03:51 PM
Malowle Re: VBA loops 09-12-2012, 03:37 PM
Malowle Re: VBA loops 09-12-2012, 03:38 PM
Malowle Re: Excel equation for... 09-12-2012, 03:40 PM
TMS Re: VBA loops 09-12-2012, 04:33 PM
Malowle Loops to calculate the... 09-12-2012, 05:52 PM
TMS Re: VBA loops 09-13-2012, 05:30 PM
  1. #1
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: VBA loops

    How about =ABS(SUMPRODUCT(SIGN(C2:C367)))
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  2. #2
    Registered User
    Join Date
    08-01-2012
    Location
    Birmigham, UK
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: VBA loops

    Thanks all for your reply.
    I am combining this code with another code in VBA and it would have been nice to have everything in vba.
    I have tried some of your suggestion but they seem to be giving something else.
    i may have expressed myself incorrectly, but what i meant was to count the rainy days, not the amount of rain in each cell.

    Malowle
    Last edited by Malowle; 08-02-2012 at 05:34 PM. Reason: No reason

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1