Sumproduct trouble

C

Carlee

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?
 
T

T. Valko

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)
 
A

aidan.heritage

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?
Click to expand...

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
 
Top