Formula Help

Wilcock1

New Member
Joined
Dec 11, 2014
Messages
25
Hi,

Please can you help with resolving a formula query that I have.

I currently have the following formula =SUMIF(BF:BF, $C$3)

R:R has various values in.

BF:BF is a column with dates in.

C3 is 01/01/19 formatted as Jan 19.

I can get the total to work if the date in BF says 01/01/19 as it matches C3 but the result that I am trying to obtain is sum anything in column R if column BF has a Jan 19 date (i.e. 02/01/19, 05/01/19, 12/01/19, etc).

Any assistance would be greatly appreciated!!

Regards

Andrew
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,719
Office Version
365
Platform
Windows
How about
=SUMIFS(R:R,BF:BF,">="&C3,BF:BF,"<="&EOMONTH(C3,0))
 

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,751
Maybe:

=SUMPRODUCT(R3:R100,--(MONTH(BF3:BF100)=MONTH(C3)),--(DAY(BF3:BF100)=DAY(C3)))

I believe in your examples, you have the date formatted as YY/MM/DD.
 

Wilcock1

New Member
Joined
Dec 11, 2014
Messages
25
Maybe:

=SUMPRODUCT(R3:R100,--(MONTH(BF3:BF100)=MONTH(C3)),--(DAY(BF3:BF100)=DAY(C3)))

I believe in your examples, you have the date formatted as YY/MM/DD.
Hi there, sorry for the delay in my reply but thanks for your resolution that's great!!
Many thanks for your help.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,154
Messages
5,466,976
Members
406,513
Latest member
t0ny84

This Week's Hot Topics

Top