If Formula suggestion

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.

=SUMPRODUCT(--('Sheet1'!A2:A200="Jan"),--('Sheet1'!B2:B100=1),'Sheet1'!C2:C100)


if the percentage is real percentage then the above should work, if it just
a header
saying Percentage and the values are integers like 100 for 100% then use 100


Regards,

Peo Sjoblom

"TJP" wrote:

> 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.