Skip to main content
edited tags; edited title
Link
user0
  • 27.1k
  • 10
  • 53
  • 78

Sum if SUMIF by month different entry locations

better name for link; fix grammar
Source Link
ale
  • 52.9k
  • 42
  • 165
  • 314

Beforehand please check the following sheetmy heresample sheet.

I'm trying to use SUMIF or any specific formula that shows the total amount of income of each month over on the side (March, April, May...)

As noticed the date (month) is not always the same on each column (Date 1, Date 2, Date 3...), it may vary.

I've tried SUMIF, FILTER, ARRAYFORMULA, but haven't gottenhad any luck.

Is there any way to do this or do I have to change the whole structure?

Beforehand please check the following sheet here.

I'm trying to use SUMIF or any specific formula that shows the total amount of income of each month over on the side (March, April, May...)

As noticed the date (month) is not always the same on each column (Date 1, Date 2, Date 3...), it may vary.

I've tried SUMIF, FILTER, ARRAYFORMULA, but haven't gotten any luck.

Is there any way to do this or do I have to change the whole structure?

Beforehand please check my sample sheet.

I'm trying to use SUMIF or any specific formula that shows the total amount of income of each month over on the side (March, April, May...)

As noticed the date (month) is not always the same on each column (Date 1, Date 2, Date 3...), it may vary.

I've tried SUMIF, FILTER, ARRAYFORMULA, but haven't had any luck.

Is there any way to do this or do I have to change the whole structure?

Beforehand please check the following sheet.   https://docs.google.com/spreadsheets/d/1gIN3Xvg59B8awxjhjjH6GxMMCY_wrvh8v6uQMVlzj68/edit?usp=sharinghere.

I'm trying to use SUMIFSUMIF or any specific formula that shows the total amount of income of each month over on the side (March, April, May...)

As noticed the date (month) is not always the same on each column (Date 1, Date 2, Date 3...), it may vary.

I've tried SUMIFSUMIF, FILTERFILTER, ARRAYFORMULAARRAYFORMULA, but haven't gotten any luck.

Is there any way to do this or do I have to change the whole structure?

Beforehand please check the following sheet. https://docs.google.com/spreadsheets/d/1gIN3Xvg59B8awxjhjjH6GxMMCY_wrvh8v6uQMVlzj68/edit?usp=sharing

I'm trying to use SUMIF or any specific formula that shows the total amount of income of each month over on the side (March, April, May...)

As noticed the date (month) is not always the same on each column (Date 1, Date 2, Date 3...), it may vary.

I've tried SUMIF, FILTER, ARRAYFORMULA, but haven't gotten any luck.

Is there any way to do this or do I have to change the whole structure?

Beforehand please check the following sheet  here.

I'm trying to use SUMIF or any specific formula that shows the total amount of income of each month over on the side (March, April, May...)

As noticed the date (month) is not always the same on each column (Date 1, Date 2, Date 3...), it may vary.

I've tried SUMIF, FILTER, ARRAYFORMULA, but haven't gotten any luck.

Is there any way to do this or do I have to change the whole structure?

added 115 characters in body
Source Link
A. C.
  • 15
  • 5
Loading
added 28 characters in body
Source Link
A. C.
  • 15
  • 5
Loading
Source Link
A. C.
  • 15
  • 5
Loading