sumif equivalent in Access

  • Thread starter Thread starter Huson
  • Start date Start date
H

Huson

is there an equivalent to sumif in Access. I very much appreciate any help. I
am using Office 2000
 
is there an equivalent to sumif in Access. I very much appreciate any help. I
am using Office 2000
Click to expand...

No SumIf but you could use Sum() with criteria.
=Sum(IIf([SomeField] = "XYZ Co.",[Amount],0))
 

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

sumifs return #value 1
SUMIF (or SUMIFS): Can I have multiple EITHER OR criteria 1
SUMIFS help page online? 3
Excel display two dates in one cell - excel 2010 2
finding a minimum 2
Excel Need aid in Excel Formulas 3
Access equivalent of Vlookup 3
access formula 3

Back
Top