software

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
One way ..

Assuming data in row2 down
and in col A are the month numbers: 1, 2,3, 4, etc

Put in AK2: =IF(A2=quot;quot;,quot;quot;,SUM(OFFSET($X2,,,,A2)))
Copy down as required
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Manosquot; wrote:
gt; Dear All
gt;
gt; I am trying to add a specific range of data
gt; Column A include a code
gt; Column B-X include actual data
gt; Culumn X- AI include budget figures.
gt; Also in cell A1i have the number of the month
gt;
gt; For example the month is 3 (March)
gt; I want in AK to create a SUMIF where the formula will sum columnsX Y Z
gt; If month goes 4 then should calculate
gt; X Y Z AA
gt; and so on
gt;
gt; Any good ideas?
gt;
gt; Thanks in advance Manos

I have the month always in A1
i change it manualy
in Column A from A5 till A1500 i have dataquot;Maxquot; gt; wrote in message
...
gt; One way ..
gt;
gt; Assuming data in row2 down
gt; and in col A are the month numbers: 1, 2,3, 4, etc
gt;
gt; Put in AK2: =IF(A2=quot;quot;,quot;quot;,SUM(OFFSET($X2,,,,A2)))
gt; Copy down as required
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;Manosquot; wrote:
gt;gt; Dear All
gt;gt;
gt;gt; I am trying to add a specific range of data
gt;gt; Column A include a code
gt;gt; Column B-X include actual data
gt;gt; Culumn X- AI include budget figures.
gt;gt; Also in cell A1i have the number of the month
gt;gt;
gt;gt; For example the month is 3 (March)
gt;gt; I want in AK to create a SUMIF where the formula will sum columnsX Y Z
gt;gt; If month goes 4 then should calculate
gt;gt; X Y Z AA
gt;gt; and so on
gt;gt;
gt;gt; Any good ideas?
gt;gt;
gt;gt; Thanks in advance Manos
quot;Manosquot; wrote:
gt; I have the month always in A1
gt; i change it manually
gt; in Column A from A5 till A1500 i have data

Put in AK5: =IF($A$1=quot;quot;,quot;quot;,SUM(OFFSET($X5,,,,$A$1)))
Copy AK5 down to AK1500
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---

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

--
Don Guillett
SalesAid Software

quot;Manosquot; gt; wrote in message
...
gt; Dear All
gt;
gt; I am trying to add a specific range of data
gt; Column A include a code
gt; Column B-X include actual data
gt; Culumn X- AI include budget figures.
gt; Also in cell A1i have the number of the month
gt;
gt; For example the month is 3 (March)
gt; I want in AK to create a SUMIF where the formula will sum columnsX Y Z
gt; If month goes 4 then should calculate
gt; X Y Z AA
gt; and so on
gt;
gt; Any good ideas?
gt;
gt; Thanks in advance Manos
gt;
A1 has the month, which i change it manualy

and form A2 - A1500 has product names and codesquot;Don Guillettquot; gt; wrote in message
...
gt; You say you have a product code and a month in col A. How?
gt; 1-222222c
gt; 222222c-1
gt; or ?
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Manosquot; gt; wrote in message
gt; ...
gt;gt; Dear All
gt;gt;
gt;gt; I am trying to add a specific range of data
gt;gt; Column A include a code
gt;gt; Column B-X include actual data
gt;gt; Culumn X- AI include budget figures.
gt;gt; Also in cell A1i have the number of the month
gt;gt;
gt;gt; For example the month is 3 (March)
gt;gt; I want in AK to create a SUMIF where the formula will sum columnsX Y Z
gt;gt; If month goes 4 then should calculate
gt;gt; X Y Z AA
gt;gt; and so on
gt;gt;
gt;gt; Any good ideas?
gt;gt;
gt;gt; Thanks in advance Manos
gt;gt;
gt;
gt;
Implemented in OP's sample file (sent over)
---------------------------
Put in Q6: =IF($F$1=quot;quot;,quot;quot;,SUM(OFFSET($D6,,,,$F$1)))
Copy down

Adapt to suit your continental Excel ..
(replace commas [separator] with semicolons)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---


This works to sum columns per month based on the date in cell A1.

=SUM(INDIRECT(quot;A5:quot;amp;CHAR(MONTH(A1) 64)amp;65536))

It might help you out.--
Flintstone
------------------------------------------------------------------------
Flintstone's Profile: www.excelforum.com/member.php...oamp;userid=15310
View this thread: www.excelforum.com/showthread...hreadid=539517Thank you MAX
It works perfectlyquot;Manosquot; gt; wrote in message
...
gt; A1 has the month, which i change it manualy
gt;
gt; and form A2 - A1500 has product names and codes
gt;
gt;
gt; quot;Don Guillettquot; gt; wrote in message
gt; ...
gt;gt; You say you have a product code and a month in col A. How?
gt;gt; 1-222222c
gt;gt; 222222c-1
gt;gt; or ?
gt;gt;
gt;gt; --
gt;gt; Don Guillett
gt;gt; SalesAid Software
gt;gt;
gt;gt; quot;Manosquot; gt; wrote in message
gt;gt; ...
gt;gt;gt; Dear All
gt;gt;gt;
gt;gt;gt; I am trying to add a specific range of data
gt;gt;gt; Column A include a code
gt;gt;gt; Column B-X include actual data
gt;gt;gt; Culumn X- AI include budget figures.
gt;gt;gt; Also in cell A1i have the number of the month
gt;gt;gt;
gt;gt;gt; For example the month is 3 (March)
gt;gt;gt; I want in AK to create a SUMIF where the formula will sum columnsX Y Z
gt;gt;gt; If month goes 4 then should calculate
gt;gt;gt; X Y Z AA
gt;gt;gt; and so on
gt;gt;gt;
gt;gt;gt; Any good ideas?
gt;gt;gt;
gt;gt;gt; Thanks in advance Manos
gt;gt;gt;
gt;gt;
gt;gt;
gt;
gt;
quot;Manosquot; wrote:
gt; Thank you MAX
gt; It works perfectly

Glad to hear that !
Thanks for the feedback ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---