Sumif using Multiple Criteria

[acool]

Hi Everyone,

I am currently trying to create a Sumif Formula which uses multiple criteria to generate an output value. In this instance, I am trying to use the criteria of "Brand Name" and then would like to sum the values for any months which fall before the current month. In this example Brand 1's value YTD value would be $97,706, as I am summing anything before the current month. Any help in creating this formula would be greatly appreciated. Picture attached below for reference. I am trying to inserting this formula into the Forecast YTD Cells in the table below.

Thank You

 

[Kaper]

To sum data from a multi row/column range it would be much better/easier to use SUMPRODUCT not SUMIF(s).
Assuming your dates are in row 3, Brands are in column D and real data starts in E3 something like:

=SUMPRODUCT(E$3:P$10,(E$2:P$2<=EOMONTH(TODAY(),-1))*(B$3:B$10=A15))

This would be formula for B15 when A15 contains a name of a brand

 

[awoohaw]

try something like this:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1			2023-07-01	2023-08-01	2023-09-01	2023-10-01	2023-11-01	2023-12-01	2024-01-01	2024-02-01	2024-03-01	2024-04-01	2024-05-01	2024-06-01	2024-07-01
2		Brand1	63	31	44	38	70	77	44	49	44	28	55	50	29
3		Brand2	57	33	76	47	61	34	79	61	41	35	30	30	59
4		Brand3	35	61	46	45	68	74	57	47	57	49	72	63	67
5		Brand4	61	47	38	73	62	60	27	68	56	40	77	51	69
6		Brand5	36	49	53	25	67	57	36	34	79	43	38	72	29
7		Brand6	62	84	34	82	36	30	46	77	85	25	54	25	62
8		Brand7	80	57	28	61	28	74	52	66	66	76	47	80	71
9
10
11		Brand:	Brand3
12		BeforeDate:	2024-02-14
13
14		Total:	433
Sheet3

Cell Formulas
Range	Formula
C12	C12	=TODAY()
C14	C14	=SUMPRODUCT(($B$2:$B$8=C11)*($C$1:$O$1<=C12)*($C$2:$O$8))

 

[Kaper]

If C12 is just TODAY, the formula would return $190,000+ for the data from post 1

 

[acool]

Thanks for your help solving this!