SUMPRODUCT WITH condition

[daveyc18]

trying to do sumproduct

=SUMPRODUCT(IF('INV36'!AF:AF=D5,1,0),'INV36'!AU:AU,'INV36'!AV:AV)

where d5 = "331B048517" (ID #)

and in INV36 tab, that ID # is in column AF...

im getting a result, but it's not the correct number

is the syntax correcT?

 

[daveyc18]

nvm

 

[Fluff]

In future please do not mark a post as the solution, when it does not contain one. Thanks