I have a sheet that will have three key columns of input.

Column one is the month (jan, feb, etc)
Column two is a percentage
Column three is a whole number

I would like to write a formula on a seperate worksheet to capture data from
these columns. Basically what I would like it to say is

If month=Jan and %=100, then use whole number from corresponding row in
column 3.

(i.e. --- 100,000 Jan 100%

Can I use a query or sum feature that will sum all whole numbers in which
Jan and 100% are present since there are mulitple rows of data. I will have
this formula for each month.

Thanks in advance for any suggestions provided.