Forum Discussion
IF Function
Hi,
Can I please have help with this one..
I am looking to do the following:
- Column M on Tab 1 has dates relating to a figure Column G, which has a project name in Column B.
- I want Tab 2 to have January to December along the top row
- Tab 2 to have Project Names from Tab 1 Column B down column A
- Figures from Tab 1, Column G relating to the dates in Column M input into the correct month column in Tab 2.
Sheet attached.
John
Like this?
6 Replies
Please give this a try...
On Gateway Sheet,
In B2
=SUMPRODUCT(('Original List '!$B$2:$B$21=$A2)*(TEXT('Original List '!$M$2:$M$21,"mmmm")=B$1)*('Original List '!$G$2:$G$21))
and copy it across and down.
I cannot get this to copy down and across to take into account the additional figures and dates per months.
I would like all the amounts per month, per project to come across to the 2nd tab.
And then totaled per month.
Please see attached.
John
Like this?
