ok, here is the problem.
In col A I have numbers (the number of articles)
In col B I have arrival date of the article
In col C I have a string which has 2 different alternatives.
I need to sum up the numbers in col A by a certain month and year, as well as differ the two strings. I have been turning my brains inside out and so far my best idea is something like:
SUMIFS(A1:A10;B1:B10;"MONTH=1";B1:B10;"YEAR=2010";C1:C10;"string")
I know I am not using the MONTH and YEAR functions in a correct way, but does anyone have a better idea on how to solve this?
Bookmarks