Help with a formula

[bitsy15]

If Column A="AK" AND Column B="1/20/2022", then I need the results from Column D AND Column E together.

[#2]

@bitsy15 But column E seems to be empty. What exactly do you need?

[#3]

Shoot, I meant Column F...

So if Column A = "AK AND Column B = "1/20/2022", I need the result to be $2,750 m (which is Column D and Column F combined)

I'm trying to populate a calendar to show the amount and revenue code on the day of service.

[#4 · Accepted solution]

@bitsy15 

With 365

= FILTER(Revenue&"-"&Code, 
  (Name="AK")*(Date=Dt))

would be an option.

[#5]

THANK YOU! It works!!!