Sumproduct trouble
 

Hi there,

I have two columns in my HQ Input Log. Column A is Month with month name
values in the column (ex. Jan, Feb, Mar etc). Column B contains numeric
values.

I also have another sheet that i user to capture values, but month.

Here is what i want to do: I want to search Column A for, a month value,
say January, and in the January row, want to display the value associated to
month January, on another sheet.

Can someone help me with this?
--
Carlee

Sumproduct trouble
 

In column A do you have only 1 instance of each month?

Are these month names TEXT entries or are they dates formatted to display
just the month name?

Assuming there is a single instance of each month name and these names are
test:

=SUMIF('HQ Input Log'!A:A,"Jan",'HQ Input Log'!B:B)

Or:

D1 = Jan

=SUMIF('HQ Input Log'!A:A,D1,'HQ Input Log'!B:B)


--
Biff
Microsoft Excel MVP


"Carlee" wrote in message
...
Hi there,

I have two columns in my HQ Input Log. Column A is Month with month name
values in the column (ex. Jan, Feb, Mar etc). Column B contains numeric
values.

I also have another sheet that i user to capture values, but month.

Here is what i want to do: I want to search Column A for, a month value,
say January, and in the January row, want to display the value associated
to
month January, on another sheet.

Can someone help me with this?
--
Carlee

Sumproduct trouble
 

On 2 Aug, 20:40, Carlee wrote:
Hi there,

I have two columns in my HQ Input Log. Column A is Month with month name
values in the column (ex. Jan, Feb, Mar etc). Column B contains numeric
values.

I also have another sheet that i user to capture values, but month.

Here is what i want to do: I want to search Column A for, a month value,
say January, and in the January row, want to display the value associated to
month January, on another sheet.

Can someone help me with this?
--
Carlee

This doesnt need sumproduct, a simple SUMIF will do it -

=SUMIF(a1:a1000,"January",B1:B1000)

If you want to summarize ALL months, then a Pivot Table would do it