Please help my brain!

[Scottyuk]

Hi everyone. Like so many on here I am a bit of a newbie to filemaker and need some help with a calculation.

Basically I have a value list with 2 entries

Yes and No

I'm trying to create a summary calculation that will show how many yes's have been selected.

This then leads on to a calculation from a field of which is called "Amount Total" as long as "Yes" has been selected from the "Yes" option of the value list.

What I am aiming for is a summary sheet which will provide the totals for how many "Yes's" there is along with the total of the "Amount Total"

I've already had a look through the forums and so far learnt much, just not what I need to get this working... Yes I feel so dumb for asking what is probably a really stupid question.

Thanks in advance for any help!!

[comment]

See if these two can help:

http://fmforums.com/forum/showpost.php?post/228583/

http://fmforums.com/forum/showpost.php?post/364978/

[Scottyuk]

Hi comment, thanks for your reply, I'm looking through the posts now :