I need to sum all the numbers in J column, where the F column is "Solgt" and the month in column H is August.
What I have done so far is this - but it does not work. I guess that it has something to do with how I used the month function.
=SUMIFS(Sheet1!J:J;Sheet1!F:F;"Solgt";Sheet1!H:H;MONTH(8))
My date is in this format - 01-12-2013
Anyone who can help ?
- Kim -
Bookmarks