SOLVED

Help with a formula

Copper Contributor

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

 

bitsy15_0-1645296988096.png

 

4 Replies

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

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.
best response confirmed by Hans Vogelaar (MVP)
Solution

@bitsy15 

With 365

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

would be an option.

THANK YOU! It works!!!
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@bitsy15 

With 365

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

would be an option.

View solution in original post