One sheet A, I want to sum a range from sheet B only if between a date range also on sheet B

[wmichael]

Hello. I am not sure about using Countifs, it's the only one I could find that performs in the way I want.

COUNTIFS(Clips!M2:Clips!M560,">"&"12/1/2020",Clips!B2:Clips!B560,"<"&"12/30/2020")

I don't know how to include an example.

Thank you in advance for your help with this.

 

[etaf]

use date value
In case there are any issues with the format
=COUNTIFS(Clips!B1:B558,">"&DATEVALUE("1 Dec 2020"),Clips!B1:B558,"<"&DATEVALUE("31 Dec 2020"))
I'm just looking at the XL2bb you have entered
EDIT
can you just put up a simple sheet , rather than the complex sheet, as i dont know what i'm supposed to be looking at at all there

 

[etaf]

Book2
	A	B
1	COUNT	SUM VALUES IN M
2	21	927864
Sheet1

Cell Formulas
Range	Formula
A2	A2	=COUNTIFS(Clips!B1:B558,">"&DATEVALUE("1 Dec 2020"),Clips!B1:B558,"<"&DATEVALUE("31 Dec 2020"))
B2	B2	=SUMIFS(Clips!M1:M558,Clips!B1:B558,">"&DATEVALUE("1 Dec 2020"),Clips!B1:B558,"<"&DATEVALUE("31 Dec 2020"))

AND Sheet Clips

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1		12/1/20											12/30/20
2		12/2/20											12/29/20
3		12/3/20											12/28/20
4		12/4/20											12/27/20
5		12/5/20											12/26/20
6		12/6/20											12/25/20
7		12/7/20											12/24/20
8		12/8/20											12/23/20
9		12/9/20											12/22/20
10		12/10/20											12/21/20
11		12/11/20											12/20/20
12		12/12/20											12/19/20
13		12/13/20											12/18/20
14		12/14/20											12/17/20
15		12/15/20											12/16/20
16		12/16/20											12/15/20
17		12/17/20											12/14/20
18		12/18/20											12/13/20
19		12/19/20											12/12/20
20		12/20/20											12/11/20
21		12/21/20											12/10/20
22		12/22/20											12/9/20
23													12/8/20
Clips

 

[wmichael]

=SUMIFS(Clips!M1:M558,Clips!B1:B558,">"&DATEVALUE("1 Dec 2020"),Clips!B1:B558,"<"&DATEVALUE("31 Dec 2020"))

YES YES Got it to work

=SUMIFS(MC!M2:M558,MC!BF2:BF558,">"&DATEVALUE("11/1/2020"),MC!BF2:BF558,"<"&DATEVALUE("11/30/2020"))

Thanks!

 

[etaf]

you are welcome
I tend to use the name MMM as 11/1/20 could be 11th Jan or 1st Nov , depending on how the format is seen, which the default is set by the PC settings , NOT excel , excel just formats how the date is displayed
BUT you should be OK , because setup as DD/MM/YYYY then it would fail with an error as there is not 30 month