Sunday, October 16, 2011

yogi_Sum A Given Column For Specified Conditions

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?

----------------------------------------