willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 888
- Office Version
- 365
- Platform
- Windows
I have the below formula for the example pic of data:
="Value Invoiced: "&DOLLAR(SUMIFS(WOR[[#All],[Amount]],WOR[[#All],[Customer]],"<>Theirs",WOR[[#All],[Date Invoiced]],">="&GraphData!$F$2,WOR[[#All],[Date Invoiced]],"<="&GraphData!$F$1),0)
(Note the table is called WOR)
I was wondering how I could add one more condition. I only want to sum unique invoice numbers (not all of the duplicates). As you can see Invoice #17125 and 15556 repeats. With this formula I would get a total of $113,488.45 when what I need is $7,313.76.
Any help would be much appreciated.
Thank you
Carla
="Value Invoiced: "&DOLLAR(SUMIFS(WOR[[#All],[Amount]],WOR[[#All],[Customer]],"<>Theirs",WOR[[#All],[Date Invoiced]],">="&GraphData!$F$2,WOR[[#All],[Date Invoiced]],"<="&GraphData!$F$1),0)
(Note the table is called WOR)
I was wondering how I could add one more condition. I only want to sum unique invoice numbers (not all of the duplicates). As you can see Invoice #17125 and 15556 repeats. With this formula I would get a total of $113,488.45 when what I need is $7,313.76.
Any help would be much appreciated.
Thank you
Carla