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