Thread: SUMIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alectrical
 
Posts: n/a
Default SUMIF

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