Forum Discussion
Solved
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 ...
Like this?
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?
Thank you that worked.
I have an additional query for the same sheet, in the same vein.
I need Tab 3 to be populated with the Project Names in Column 1 and corresponding Project Start Dtates organised to the correct monthly column using the dates from Tab 1, Column N.
Can you help?John
