Profile

Cover photo
miguel cubeles
Works at Unitec New Zeland
Lives in Auckland
29 followers|275,890 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...

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

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
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
Communities
4 communities
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
Work
Occupation
Computer trainer
Employment
  • Unitec New Zeland
    Computer trainer, present
Basic Information
Gender
Male