If I have the following data in columns A to D:
A B C D
G 2 H 5
2 3 H 8
G 4 H 9
5 5 3 5

Can anyone tell me how to sum all the occurrences of "G" in column A AND "H"
in column C, with the total number of occurrences in cell E2.

Thanks
Alec

Hi

Try something like:
=SUMPRODUCT((A2:A25="G")*(C2:C25="H"))

Hope this helps.
Andy

"Alectrical" wrote in message
...
If I have the following data in columns A to D:
A B C D
G 2 H 5
2 3 H 8
G 4 H 9
5 5 3 5

Can anyone tell me how to sum all the occurrences of "G" in column A AND
"H"
in column C, with the total number of occurrences in cell E2.

Thanks
Alec

Thanks Andy, this works a treat.

"Andy" wrote:

Hi

Try something like:
=SUMPRODUCT((A2:A25="G")*(C2:C25="H"))

Hope this helps.
Andy

"Alectrical" wrote in message
...
If I have the following data in columns A to D:
A B C D
G 2 H 5
2 3 H 8
G 4 H 9
5 5 3 5

Can anyone tell me how to sum all the occurrences of "G" in column A AND
"H"
in column C, with the total number of occurrences in cell E2.

Thanks
Alec

Andy,
I am seeking the answer to a slightly different version of this thread
question. I have the following list:

Date Group Sold
1-Jan 11000 100
3-Jan 11000 100
15-Jan 12050 500
18-Jan 13150 400
18-Jan 14250 325
21-Jan 15000 200
22-Jan 15000 200
23-Jan 11000 100
24-Jan 15000 200

On a separate worksheet I just want to have a single row for each "group"
and the adjacent column with total sales by group irrespective of date. I
have tried
=SUMIF($B$2:$B$10,"="&B2,$C$2:$C$10) and copying it down but it is not
delivering the correct results. Clearly it is wrong. Any ideas?

Thanks,
Kem
"Andy" wrote:

Hi

Try something like:
=SUMPRODUCT((A2:A25="G")*(C2:C25="H"))

Hope this helps.
Andy

"Alectrical" wrote in message
...
If I have the following data in columns A to D:
A B C D
G 2 H 5
2 3 H 8
G 4 H 9
5 5 3 5

Can anyone tell me how to sum all the occurrences of "G" in column A AND
"H"
in column C, with the total number of occurrences in cell E2.

Thanks
Alec

Hi

I would suggest using a Pivot Table for this. This is the best way to
summarize information.
The option is under Data/Pivot Table and Chart.
An introduction to pivot tables is he
http://peltiertech.com/Excel/Pivots/pivotstart.htm

Hope this helps.
Andy.

"KemS" wrote in message
...
Andy,
I am seeking the answer to a slightly different version of this thread
question. I have the following list:

Date Group Sold
1-Jan 11000 100
3-Jan 11000 100
15-Jan 12050 500
18-Jan 13150 400
18-Jan 14250 325
21-Jan 15000 200
22-Jan 15000 200
23-Jan 11000 100
24-Jan 15000 200

On a separate worksheet I just want to have a single row for each "group"
and the adjacent column with total sales by group irrespective of date. I
have tried
=SUMIF($B$2:$B$10,"="&B2,$C$2:$C$10) and copying it down but it is not
delivering the correct results. Clearly it is wrong. Any ideas?

Thanks,
Kem
"Andy" wrote:

Hi

Try something like:
=SUMPRODUCT((A2:A25="G")*(C2:C25="H"))

Hope this helps.
Andy

"Alectrical" wrote in message
...
If I have the following data in columns A to D:
A B C D
G 2 H 5
2 3 H 8
G 4 H 9
5 5 3 5

Can anyone tell me how to sum all the occurrences of "G" in column A
AND
"H"
in column C, with the total number of occurrences in cell E2.

Thanks
Alec