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.