Sumif(s) not working

[craig2525]

Hello all,

I am trying to create a formula to sum what is in 1 column (or a cell value) based on what I see in 2 other columns. I need to sum what is in column B based on Columns A and C. I want to sum column B for PM in column A and 7/13/2024 in column C.

Column A	Column B	Column C
PM	1​	7/13/2024​
CM	2.5​	7/15/2024​
PM	7​	7/16/2024​
PM		7/15/2024​
PM	1​	7/13/2024​
CE	6​	7/15/2024​
CE	3.5​	7/13/2024​
PM		7/13/2024​

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F
1	Column A	Column B	Column C			13/07/2024
2	PM	1	13/07/2024		PM	2
3	CM	2.5	15/07/2024
4	PM	7	16/07/2024
5	PM		15/07/2024
6	PM	1	13/07/2024
7	CE	6	15/07/2024
8	CE	3.5	13/07/2024
9	PM		13/07/2024
Data

Cell Formulas
Range	Formula
F2	F2	=SUMIFS(B:B,A:A,E2,C:C,F1)

 

[craig2525]

Perfect. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.