HLOOKUP Function

  • Thread starter Thread starter Alicia
  • Start date Start date
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
 
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
 
Back
Top