....at least for me.

WinXP - FMP Dev 6.0v4

I have 11 fields - 5 fields in 2 columns with 2 Total fields.

The first colmn (items 1 thru 5) are a choice of A or B.
The second column is a sub total (number) based on choice A or B.

I am trying to have the Total fields calculate the numbers based on
the selection of A or B. Column 2 is a calculation and can be any
number.

Column 1 Column 2
-------------- --------------
1 (is A) 40.00
2 (is B) 03.25
3 (is B) 01.75
4 (is A) 30.00
5 (is A) 20.00
I would need to get the following totals based on above example
A Total 90.00
B Total 05.00

I do not know how to tell my total fields to add up only the numbers
with matching values since the numbers in column 2 will change
depending on what the user selects in Column 1 (A or B).

I've read thru the newsgroup and Scriptology and I am missing the
trick I need! Please help!

Any tips, tricks or alcohol would be great! Thanks!

VoicesInMyHead