Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding Number if equals a code

Status
Not open for further replies.

rschkrt

MIS
Apr 24, 2002
13
US
Adding number if equals a code
code number
300 5
310 6
300 4
300 5
315 7

if code = 300 then add all the number

code 300 would be 14

thank you
 
Use:

if {table.code} = 300 then {table.number}

Then right click on this formula and insert a summary (sum).

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top