View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
 
Posts: n/a
Default SUM a range of sales based on month

You say you have a product code and a month in col A. How?
1-222222c
222222c-1
or ?

--
Don Guillett
SalesAid Software

"Manos" wrote in message
...
Dear All

I am trying to add a specific range of data
Column A include a code
Column B-X include actual data
Culumn X- AI include budget figures.
Also in cell A1i have the number of the month

For example the month is 3 (March)
I want in AK to create a SUMIF where the formula will sum columnsX+Y+Z
If month goes 4 then should calculate
X+Y+Z+AA
and so on

Any good ideas?

Thanks in advance Manos