Conditional SUM

A

an

Hello.
In one table I have IdPassage, IdChunk, and ChunkValue
fields.
The Passage is composed for Chunks. The addition the Sum
of Chunks is the length of the Passage.
In a Form I need to SUM the ChunkValue, only of the same
Passage.
How I can make this, please?

Anticipatedly grateful.
an
 
J

JulieD

Hi

type the passage id in say cell A2 on the sheet that you want to display the
sum
in B2 (or where you want the total) type
=SUMIF(Sheet1!$A$2:$A$20000,A2,Sheet1!$C$2:$C$20000)
where Sheet1!$A$2:$A$20000 is the range containing the IdPassage information
and
Sheet1!$C$2:$C$20000 is the range containing the ChunkValue.

Hope this helps
Cheers
JulieD
 
J

JulieD

Hi

you'll need to use the DSUM function
=DSum("chunkvalue","Table3","passageid=combo0")
where Table3 is the table containing the fields and combo0 is the control on
the form containg the passage you're interested in.

Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional SUM, in Textbox 4
I need help with combo boxes & lookups in Access, please? 2
Thread contention and static methods 5
Sum Days into Weeks 1
Sum value in all columns that their title is the same 1
Access Daily Entry with multiple entries per field 0
Variable row number in Sum($A$1:A10) formula 3
Sum YTD Budget 4

Top