Sumproduct

B

blkane

Below is a formula I found/developed for my use. It looks at 4 separate
criterian and sums like items together. This is used to create journal
entries of banking data into our general ledger. This was a godsend to
reduce redundant postings to my ledger.

My question is what does the character "--" do? I research sumproduct in
Excel help and it never mentioned any special characters. I only learned how
to use them from another website. However, it doesn't explain what it is or
why it makes the formula work.

Can anyone fill me in on what the "--" is? And, are there other special
characters used with this formula for other purposes? I would love to kow.

Thanks

=SUMPRODUCT(--(conversiondataA=$A8),--(ConversiondataB=$B8),--(ConversiondataC=$C8),--(ConversiondataD=$D8),ConversiondataE)
 
B

blkane

thanks for quick response. Yes, it does help. The formula wouldn't work for
me with the -- so I was happy I stumbled upon it. I kept getting #value's.
 

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

Top