Lookup (?) criteria from two columns to return the value from a third

[ali_jellybean]

Hello,

I'm trying to create a system where I can add project funding into a list (left image) and then have a table that will show this funding spread across the year (as in right image). I'm wondering if there is a formula that would, in the yellow cell for example, look in the list for the date in the first column AND the project in the second column and if both of these were present it would return the amount that's in the third column.

 

[hagia_sofia]

You could e.g. use SUMIFS as a lookup formula - provided that the "Date" header is in A1 you could use just one formula in G2:

=SUMIFS(C2:C5,B2:B5,F2:F4,A2:A5,G1:K1)

 

[Dave Patton]

You may want to watch for and experiment with Pivotby; it may still be in test mode and not released to everyone.

Groupby_a.xlsx
	A	B	C	D	E	F	G	H	I
1
2	Date	Project	Amount			Jul-24	Aug-24	Oct-24	Total
3	Jul-24	Project 1	100		Project 1	100	80		180
4	Aug-24	Project 2	50		Project 2		50		50
5	Aug-24	Project 1	80		Project 3			75	75
6	Oct-24	Project 3	75		Total	100	130	75	305
7
1b

Cell Formulas
Range	Formula
E2:I6	E2	=PIVOTBY(B3:B6,A3:A6,C3:C6,SUM)
Dynamic array formulas.

 

[ali_jellybean]

Thanks so much, that's really helped