SUMIFS FORMULA?

[cdmurray]

I have a file where I have a ref # (column A) and below is a summary of those ref #'s and the hours worked on it by employee each month.

How do I get the sum of those ref #'s to appear in month applicable?

Ref #	Jun-21	Jul-21	Aug-21		Longstop
Finance 1					12/17/2021
Finance 2					12/17/2021
Finance 3					12/17/2021
Finance 4					12/17/2021
Finance 5					12/17/2021
Finance 6					6/17/2022
Finance 7					12/17/2021
Finance 8					12/17/2021
Finance 9					12/17/2021
Finance 10					6/17/2021
Finance 11
Finance 12
Summary of Time Spent
			Hours spent
Ref #	Staff member	Notes	Jun-21	Jul-21	Aug-21	Sep-21
Finance 1	JB
Finance 1	GP
Finance 1	WC	Accounts Payable Invoices	3	3	3
Finance 1	RZ	Accounts Payable Invoices, Check Runs, Vendor Inquiries, etc.	70	175	157.5
Finance 1	PM	Signing A/P Checks		0.5	0.5
Finance 1	RM	Venues Check Deposits	1	1	1
Finance 10	BG	Lot.to Monthly accounts prep		4	4
Finance 10	IS	Lot.to (Payment run's and ad hoc tasks)	2	2.5	2.5
Finance 10	JH	Lot.to Bank and AP processing	2	3	3
Finance 11	BG	Lot.to Tax pack 2020			5

 

[kweaver]

How about this in B3 and filled down and across?

=SUMPRODUCT(($A3=$A$23:$A$32)*D$23:D$32)

 

[Eric W]

Or:

=SUMIF($A$23:$A$32,$A3,D$23:D$32)

 

[cdmurray]

=SUMPRODUCT(($A3=$A$23:$A$32)*D$23:D$32)

That worked perfectly. Thank you so much.

 

[cdmurray]

Or:

=SUMIF($A$23:$A$32,$A3,D$23:D$32)

Thank you!