0

I need to sum values in one column where two other columns meet certain criteria.

Column A has the item name Column F has its value Column G has the date it was bought

What I need to do is get the sales value from Col F for each item individually from A but for different months from G Can anyone help please?

1

You need the SUMIFS function. For example:

=SUMIFS(F:F,A:A,some_criteria,G:G,some_criteria)

Try that out and let us know if you struggle with anything.

If you want to compare months you might be better off creating another column containing the month numbers

0

You need to use sumproduct here

=SUMPRODUCT((MONTH(G1:G7)=1)*(A1:A7="a")*F1:F7)

Check if the month is January (1) AND item is "a" to SUM column F

adjust as needed. e.g.

=SUMPRODUCT((MONTH(G:G)=1)*(A:A="a")*F:F)

This roughly translates to sum(True*True*F) or sum(1*1*F) if they match.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.