Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
Katrine said:
Hi, I too have a question in this category, i think... :-)
I want to sum specific rows by the names like the following:
I Monday I 1000 I
I Tuesday I 1100 I
I Monday I 1200 I
I Tuesday I 1400 I
I Monday I 1300 I
I Tuesday I 1000 I
How do i sum all "Monday"-rows and all "Tuesday"-rows without having to mark them manually? Can i create somekind of rule so i just need to say =sum(monday) for instance?
----------------------------------------
Katrine said:
Hi, I too have a question in this category, i think... :-)
I want to sum specific rows by the names like the following:
I Monday I 1000 I
I Tuesday I 1100 I
I Monday I 1200 I
I Tuesday I 1400 I
I Monday I 1300 I
I Tuesday I 1000 I
How do i sum all "Monday"-rows and all "Tuesday"-rows without having to mark them manually? Can i create somekind of rule so i just need to say =sum(monday) for instance?
----------------------------------------
No comments:
Post a Comment