Possible to do without a Macro?

[coryando]

Hi google,

Fresh out of college with a new job and they gave me a task. My intuition tells me this should be possible to do without a Macro, but we will see. I'm just new to VBA and not sure how to code this problem either.


Order Number Next Order Number ...
Product Product Coming In Delivery Date Delivery Date
1 (Amount 1 coming in) (Amount 1 coming in) ...
2 (Amount 2 coming in) (Amount 2 coming in) ...
3 (Amount 3 coming in) (Amount 3 coming in) ...

What I am trying to do is make excel sum all the products coming in that current day. Across all the orders.

Any advice would be greatly appreciated!

Thanks.

 

[Ron Rosenfeld]

Hi google,

Fresh out of college with a new job and they gave me a task. My intuition tells me this should be possible to do without a Macro, but we will see. I'm just new to VBA and not sure how to code this problem either.


Order Number Next Order Number ...
Product Product Coming In Delivery Date Delivery Date
1 (Amount 1 coming in) (Amount 1 coming in) ...
2 (Amount 2 coming in) (Amount 2 coming in) ...
3 (Amount 3 coming in) (Amount 3 coming in) ...

What I am trying to do is make excel sum all the products coming in that current day. Across all the orders.

Any advice would be greatly appreciated!

Thanks.

Hard to tell as the format of your data is not clear. But you could look at either the Pivot Table tool; or the SUMIF or SUMIFS functions.

 

[coryando]

Hard to tell as the format of your data is not clear. But you could look at either the Pivot Table tool; or the SUMIF or SUMIFS functions.

The problem that I find with SUMIF is that I do not know how many orders will be in the sheet. So I will not know the amount of columns to sum across. The delivery date will change over every order. Is there any way that I could post the sheet?

 

[Ron Rosenfeld]

The problem that I find with SUMIF is that I do not know how many orders will be in the sheet. So I will not know the amount of columns to sum across. The delivery date will change over every order. Is there any way that I could post the sheet?

So long as you include more columns than the maximum number SUMIF shoudl work.

There are number of public sites where you can post a file, and then post a link here. Two popular sites are OneDrive & DropBox but there are others.