HLOOKUP Function

A

Alicia

Hello,

I am trying to create a table that sorts orders into
months (horazontally) accross the page. I have another
worksheet with all of this information in it. How do i
create a command that finds all the late orders in Jan 03
and totals them up and puts the numeric number in the jan
03 Collum?

I have been told that i would need to use a lookup
function, how do i use this function?

Thanking you in advance.

Alicia
Brisbane Australia
 
J

Jerry W. Lewis

Without more information, it is difficult to give a specific answer.
The usual approaches to conditional sums are to use either SUMIF or
SUMPRODUCT. Help for SUMIF is pretty clear. SUMPRODUCT would be used like
=SUMPRODUCT( (<condition1>)*(<condition2>)*..., <column to be summed>)

Jerry
 
Top