Hello All,
Here is my situation that I want to see if possible. I have a sheet that contains three columns related to physical project areas. Column 1 contains a date of when the project comes to us, column 2 contains how the project has been divided (Ii.e. 5 lots, 6 lots, etc.) so it will contain only a number, column 3 will have the size of the project (i.e. lot 1 is 12 Acres), the entry just is say the number 12.
Anyways in Cell E2, E3, E4, E5, they want us to put information of all the projects divided into quarter reports, so E2 is labeled 1st Quarter, etc. So i was wondering if there was a way to just add an If statement that would look through all of Column 1, it the date in the cell matches the quarter, it would take the entry in column 2 and add them all together. So lets say A5, A7, A19 area all within the 1st Quarter of the Year (January to March) it would then add up Cells B5, B7, and B19 into E2, so if B5 = 10, B7 = 3, & B19 = 7, then E2 = 20. Please let me know if this is possible using just an IF State. I know i could properly do something with VBA but the person requesting this just like VBA formulas in a project so i just want to see if it's possible using formulas instead. Thank you for any assistance that you can provide. Please also let me know if this is impossible and that way i can see about an alternative method.
Here is my situation that I want to see if possible. I have a sheet that contains three columns related to physical project areas. Column 1 contains a date of when the project comes to us, column 2 contains how the project has been divided (Ii.e. 5 lots, 6 lots, etc.) so it will contain only a number, column 3 will have the size of the project (i.e. lot 1 is 12 Acres), the entry just is say the number 12.
Anyways in Cell E2, E3, E4, E5, they want us to put information of all the projects divided into quarter reports, so E2 is labeled 1st Quarter, etc. So i was wondering if there was a way to just add an If statement that would look through all of Column 1, it the date in the cell matches the quarter, it would take the entry in column 2 and add them all together. So lets say A5, A7, A19 area all within the 1st Quarter of the Year (January to March) it would then add up Cells B5, B7, and B19 into E2, so if B5 = 10, B7 = 3, & B19 = 7, then E2 = 20. Please let me know if this is possible using just an IF State. I know i could properly do something with VBA but the person requesting this just like VBA formulas in a project so i just want to see if it's possible using formulas instead. Thank you for any assistance that you can provide. Please also let me know if this is impossible and that way i can see about an alternative method.