sumif help working out sales in a month

[tintrumpet]

i need to keep tabs on my sales team. i want to calculate their sales generated in a period (month). so i have a column with order date in, and another column with the order value. i would like to sum the sales within january for example.

should be straight forward, but cant figure it out.
thanks in advance
TT

[Don]

Hi there!

This is a perfect example of when to use a pivottable in Excel. (insert tab > PivotTable). If you can include a sample workbook I can walk you through the steps needed to get the desired output specific to your data.

Or, you could create another column that contains only the month's number, using =Month(A1) and then copying that down for the entire column; then, use a sumif formula like this:

Code: Select all

=SUMIF(A1:A3,2,B1:B3)

Where the month column would be in column A, the amount to sum in column B, and the month for which you want to sum in the middle argument stated as a number.

hope this helps!

happy new year!

[tintrumpet]

thanks Don, the 2nd option was exactly what i was after. thanks everso much
ben