Help with Sumifs formula

[willow1985]

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

 

[willow1985]

Ah I see, I did not account for the blank cells in the formula when I was Making sure not to Sum duplicate Q/O Numbers.

Thank you very much!

 

[DanteAmor]

Again with pleasure. Thanks for the feedback