Profile

Cover photo
miguel cubeles
Works at Unitec New Zeland
Lives in Auckland
30 followers|219,290 views
AboutPostsPhotosYouTube

Stream

miguel cubeles

Discussion  - 
 
Sum a range, if condition is true, and the date in column date falls between given start and end date.
5
2
Huy Ngo Huu's profile photomiguel cubeles's profile photoBart Schuck's profile photo
4 comments
 
Okay, so your totals are reversed. The actual odd total is what your graphic shows as the even total and visa-verse. Here are the formulas for both without using helper columns:

Odd:
=SUMPRODUCT(--((A3:A23/2)/INT(A3:A23/2)>1),--(B3:B23>=H3),--(B3:B23<=I3),--(C3:C23))

Even:
=SUMPRODUCT(--((A3:A23/2)/INT(A3:A23/2)=1),--(B3:B23>=H3),--(B3:B23<=I3),--(C3:C23))
Add a comment...
 
I just discovered Anaconda.....Fantastic.....nice environment.
1
1
miguel cubeles's profile photoFrancis Dagenais's profile photoDave Kliczbor's profile photo
4 comments
 
+Francis Dagenais I tried it once. It installs python, the ipython shell (QT and cmd version), a web-based scrapbook editor (incl. web server), a module manager and prepares the environment ... you just install it and everything's there. Perfect for the Windows user who wants to start with programming -- and perfect for the Linux user who is forced to code Python on Windows.
Add a comment...
Sally Conway was tagged in miguel cubeles's photo.

miguel cubeles

Shared publicly  - 
1

miguel cubeles

Shared publicly  - 
 
Sydney
1
Zoraida TB's profile photo
 
guapíssim
Have him in circles
30 people
Highway 1's profile photo
FILM TRAILER ZONE'S's profile photo
Windy Miller's profile photo
U Darn Goofed's profile photo
CarCam NZ's profile photo
Rosa Cubeles's profile photo
Hisham Aboalamal's profile photo
Ciara Slater's profile photo
Lesley White's profile photo

Communities

4 communities

miguel cubeles

Shared publicly  - 
 
My 19 year old Brother Sam works at Smith and Caughys, and just the other day, he saw Len brown, mayor of Auckland. And he knows how much I love Writing about Auckland.So he gladly asked for an Autograph. I'm guessing that ...
1

miguel cubeles

Shared publicly  - 
 
Mar 27, 2011
1
Zoraida TB's profile photo
 
no sé on es posa me gusta, però me gusta mucho
 ·  Translate
People
Have him in circles
30 people
Highway 1's profile photo
FILM TRAILER ZONE'S's profile photo
Windy Miller's profile photo
U Darn Goofed's profile photo
CarCam NZ's profile photo
Rosa Cubeles's profile photo
Hisham Aboalamal's profile photo
Ciara Slater's profile photo
Lesley White's profile photo
Communities
4 communities
Basic Information
Gender
Male
Work
Occupation
Computer trainer
Employment
  • Unitec New Zeland
    Computer trainer, present
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Auckland
Previously
Spain
Links
Other profiles