Conditional SUM

  • Thread starter Thread starter an
  • Start date Start date
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
 
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
 
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
 
You must log in or register to reply here.

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
Open specific hyperlink (accept) automatically in email with outlook 0
Text Formatted as French 1
I need help with combo boxes & lookups in Access, please? 2
Flesh Kincaid Reading Level 5
CONCATENATE FUNCTION! 4
Thread contention and static methods 5
Numbers showing Up Centered in Cell ? 1

Back
Top