Help with a formula

New Contributor

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




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)


With 365

= FILTER(Revenue&"-"&Code, 

would be an option.

THANK YOU! It works!!!