Sum of Alternate Cells
 

Say I have 3 people in an office, the names of which I write in Column A
(starting at A3, A4 & A5).

Each day I could serve them with four different kinds of drinks. Say COKE,
PEPSI, FANTA and RED BULL.

So now I write these drinks in different cells, say COKE (B2), PEPSI (C2),
FANTA (D2) and similarly RED BULL (E2).

Because these drinks can be served on each day, I have merged the cells B1,
C1, D1 and E1, and written the date in this merged cell, begining with
January 01, 2008.

Now I make similar columns to the right for each day of the year. Say one
full month through January 31, 2008.

The first four cells for the first person, i.e. for January 01, 2008 are
B3, C3, D3 and E3.

This way the data for January 31, 2008 finishes at
DR3, DS3, DT3 and DU3.

The quantity of a drink that he has on any day is written under that
particular date, under the specific type of drink. There is no restruction
to the number of drinks a person can have on each day. Also he could have
one, two, three or all four types of drinks each day.

Now, at the end of the month I want to know the number of
COKES/PEPSIS/FANTAS/RED BULLs he has had in the month.

This total (or sum) I want at the end of the month, i.e. the cell where I
would like to put my formula for each of these drinks would be

DV3 (for COKE), DW3 (for PEPSI), DX3 (FOR FANTA) and DY3 (for RED BULL).

Questions: - How do I get the total for the four different sets of cells.
That is I should be able to see in the Formula Cell, the number of
COKES/PEPSIS/FANTAS/RED BULLS that a person has had in the month of January.

Sum of Alternate Cells
 

=SUMIF($B$2:$DU$2,"COKE",$B3:$DU3)

etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Kamal Singh Oberh" wrote in
message ...
Say I have 3 people in an office, the names of which I write in Column A
(starting at A3, A4 & A5).

Each day I could serve them with four different kinds of drinks. Say
COKE,
PEPSI, FANTA and RED BULL.

So now I write these drinks in different cells, say COKE (B2), PEPSI (C2),
FANTA (D2) and similarly RED BULL (E2).

Because these drinks can be served on each day, I have merged the cells
B1,
C1, D1 and E1, and written the date in this merged cell, begining with
January 01, 2008.

Now I make similar columns to the right for each day of the year. Say one
full month through January 31, 2008.

The first four cells for the first person, i.e. for January 01, 2008 are
B3, C3, D3 and E3.

This way the data for January 31, 2008 finishes at
DR3, DS3, DT3 and DU3.

The quantity of a drink that he has on any day is written under that
particular date, under the specific type of drink. There is no
restruction
to the number of drinks a person can have on each day. Also he could have
one, two, three or all four types of drinks each day.

Now, at the end of the month I want to know the number of
COKES/PEPSIS/FANTAS/RED BULLs he has had in the month.

This total (or sum) I want at the end of the month, i.e. the cell where I
would like to put my formula for each of these drinks would be

DV3 (for COKE), DW3 (for PEPSI), DX3 (FOR FANTA) and DY3 (for RED BULL).

Questions: - How do I get the total for the four different sets of cells.
That is I should be able to see in the Formula Cell, the number of
COKES/PEPSIS/FANTAS/RED BULLS that a person has had in the month of
January.

Sum of Alternate Cells
 

May I please have your e-mail id please. I tried what you had sent - but it
didn't work. May be a look at the data sheet will give you a btter picture
of what i want.

"Bob Phillips" wrote:

=SUMIF($B$2:$DU$2,"COKE",$B3:$DU3)

etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Kamal Singh Oberh" wrote in
message ...
Say I have 3 people in an office, the names of which I write in Column A
(starting at A3, A4 & A5).

Each day I could serve them with four different kinds of drinks. Say
COKE,
PEPSI, FANTA and RED BULL.

So now I write these drinks in different cells, say COKE (B2), PEPSI (C2),
FANTA (D2) and similarly RED BULL (E2).

Because these drinks can be served on each day, I have merged the cells
B1,
C1, D1 and E1, and written the date in this merged cell, begining with
January 01, 2008.

Now I make similar columns to the right for each day of the year. Say one
full month through January 31, 2008.

The first four cells for the first person, i.e. for January 01, 2008 are
B3, C3, D3 and E3.

This way the data for January 31, 2008 finishes at
DR3, DS3, DT3 and DU3.

The quantity of a drink that he has on any day is written under that
particular date, under the specific type of drink. There is no
restruction
to the number of drinks a person can have on each day. Also he could have
one, two, three or all four types of drinks each day.

Now, at the end of the month I want to know the number of
COKES/PEPSIS/FANTAS/RED BULLs he has had in the month.

This total (or sum) I want at the end of the month, i.e. the cell where I
would like to put my formula for each of these drinks would be

DV3 (for COKE), DW3 (for PEPSI), DX3 (FOR FANTA) and DY3 (for RED BULL).

Questions: - How do I get the total for the four different sets of cells.
That is I should be able to see in the Formula Cell, the number of
COKES/PEPSIS/FANTAS/RED BULLS that a person has had in the month of
January.

Sum of Alternate Cells
 

Trying to total window/frame on three different worksheets into one work
sheet. I typed the formula like like thisL
=SUMIF(basement floor!$J$2:$J$20,"Window/Frame"+first
floor!$J2:$J$20,"Window/Frame"+Second Floor!$J2:$J$20,"Window/Frame")

Even did it with just one Window/Frame at the end of the formula and
parentheses at the end of each ("Window/Frame") and it still didn't work.
What am I doing wrong.

Thanks
Kyle

"Bob Phillips" wrote:

=SUMIF($B$2:$DU$2,"COKE",$B3:$DU3)

etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Kamal Singh Oberh" wrote in
message ...
Say I have 3 people in an office, the names of which I write in Column A
(starting at A3, A4 & A5).

Each day I could serve them with four different kinds of drinks. Say
COKE,
PEPSI, FANTA and RED BULL.

So now I write these drinks in different cells, say COKE (B2), PEPSI (C2),
FANTA (D2) and similarly RED BULL (E2).

Because these drinks can be served on each day, I have merged the cells
B1,
C1, D1 and E1, and written the date in this merged cell, begining with
January 01, 2008.

Now I make similar columns to the right for each day of the year. Say one
full month through January 31, 2008.

The first four cells for the first person, i.e. for January 01, 2008 are
B3, C3, D3 and E3.

This way the data for January 31, 2008 finishes at
DR3, DS3, DT3 and DU3.

The quantity of a drink that he has on any day is written under that
particular date, under the specific type of drink. There is no
restruction
to the number of drinks a person can have on each day. Also he could have
one, two, three or all four types of drinks each day.

Now, at the end of the month I want to know the number of
COKES/PEPSIS/FANTAS/RED BULLs he has had in the month.

This total (or sum) I want at the end of the month, i.e. the cell where I
would like to put my formula for each of these drinks would be

DV3 (for COKE), DW3 (for PEPSI), DX3 (FOR FANTA) and DY3 (for RED BULL).

Questions: - How do I get the total for the four different sets of cells.
That is I should be able to see in the Formula Cell, the number of
COKES/PEPSIS/FANTAS/RED BULLS that a person has had in the month of
January.

Sum of Alternate Cells
 

=COUNTIF('basement floor'!$J$2:$J$20,"Window/Frame")+
COUNTIF('first floor'!$J2:$J$20,"Window/Frame)+
COUNTIF('Second Floor'!$J2:$J$20,"Window/Frame")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"ktbro23" wrote in message
...
Trying to total window/frame on three different worksheets into one work
sheet. I typed the formula like like thisL
=SUMIF(basement floor!$J$2:$J$20,"Window/Frame"+first
floor!$J2:$J$20,"Window/Frame"+Second Floor!$J2:$J$20,"Window/Frame")

Even did it with just one Window/Frame at the end of the formula and
parentheses at the end of each ("Window/Frame") and it still didn't work.
What am I doing wrong.

Thanks
Kyle

"Bob Phillips" wrote:

=SUMIF($B$2:$DU$2,"COKE",$B3:$DU3)

etc.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Kamal Singh Oberh" wrote in
message ...
Say I have 3 people in an office, the names of which I write in Column
A
(starting at A3, A4 & A5).

Each day I could serve them with four different kinds of drinks. Say
COKE,
PEPSI, FANTA and RED BULL.

So now I write these drinks in different cells, say COKE (B2), PEPSI
(C2),
FANTA (D2) and similarly RED BULL (E2).

Because these drinks can be served on each day, I have merged the cells
B1,
C1, D1 and E1, and written the date in this merged cell, begining with
January 01, 2008.

Now I make similar columns to the right for each day of the year. Say
one
full month through January 31, 2008.

The first four cells for the first person, i.e. for January 01, 2008
are
B3, C3, D3 and E3.

This way the data for January 31, 2008 finishes at
DR3, DS3, DT3 and DU3.

The quantity of a drink that he has on any day is written under that
particular date, under the specific type of drink. There is no
restruction
to the number of drinks a person can have on each day. Also he could
have
one, two, three or all four types of drinks each day.

Now, at the end of the month I want to know the number of
COKES/PEPSIS/FANTAS/RED BULLs he has had in the month.

This total (or sum) I want at the end of the month, i.e. the cell where
I
would like to put my formula for each of these drinks would be

DV3 (for COKE), DW3 (for PEPSI), DX3 (FOR FANTA) and DY3 (for RED
BULL).

Questions: - How do I get the total for the four different sets of
cells.
That is I should be able to see in the Formula Cell, the number of
COKES/PEPSIS/FANTAS/RED BULLS that a person has had in the month of
January.