The problem is that in column A:A I have multiple repeated dates (one date per each campaign ID), like so:ĭate (A:A) / Campaign ID (B:B) / Amount spent (C:C)Īnother issue is that I don't know all Campaign IDs (column B:B) for all of the campaigns listed in my spreadsheet. So I need to find out which campaign has the highest Amount spent for the date range between April 1st to April 5th. I have set of columns that I am attempting to calculate the combined total of those columns then subtract from that total 8, if the difference after 8 is equal to or less than 0 I want to only show zero in the column I am doing this formula in. The "2385481" is a unique campaign ID (column B:B). The C:C column is the Amount spend per advertising campaign. When I apply the formula only for April 1st it works fine:Īnd here’s my formula for the Date range: But when I tried to use a date range it returns a 0 value. Thank you so much for your tutorials! I tried your formula and it worked for one date.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |