Thread
:
SUM a range of sales based on month
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
Posts: n/a
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
Reply With Quote