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