• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Summarise (count/sum) data based on a excel table

I

inddon

Member
Hello There,

I have a excel table which lists summarised data, based on operation of a file. It includes a file name processed on a particular date, and the various totals of it's operation (eg. total : Matched transaction, transaction having No PO, etc.)

On another worksheet it gives a month wise operation overview. I would like to know how this could be achieved using actual VBA code and through formula.
Based on particular month:
-How many files were processed
-Sum of all transactions that were matched, has No PO, etc.

For a better explanation, I have attached a sample workbook for your reference.

Looking forward to hear from you.

Regards,
Don
 

Attachments

  • Sample Workbook Get Summary from Table.xlsm
    26.4 KB · Views: 4
I would do this using the formulae =Countifs and =Sumifs as appropriate. Here are links to tutorials.

MS Excel: How to use the COUNTIFS Function (WS)

This Excel tutorial explains how to use the Excel COUNTIFS function with syntax and examples. The Microsoft Excel COUNTIFS function counts the number of cells in a range, that meets a single or multiple criteria.
www.techonthenet.com www.techonthenet.com

MS Excel: How to use the SUMIFS Function (WS)

This Excel tutorial explains how to use the Excel SUMIFS function with syntax and examples. The Microsoft Excel SUMIFS function adds all numbers in a range of cells, based on a single or multiple criteria.
www.techonthenet.com www.techonthenet.com
 
AlanSidman said:
I would do this using the formulae =Countifs and =Sumifs as appropriate. Here are links to tutorials.

MS Excel: How to use the COUNTIFS Function (WS)

This Excel tutorial explains how to use the Excel COUNTIFS function with syntax and examples. The Microsoft Excel COUNTIFS function counts the number of cells in a range, that meets a single or multiple criteria.
www.techonthenet.com www.techonthenet.com

MS Excel: How to use the SUMIFS Function (WS)

This Excel tutorial explains how to use the Excel SUMIFS function with syntax and examples. The Microsoft Excel SUMIFS function adds all numbers in a range of cells, based on a single or multiple criteria.
www.techonthenet.com www.techonthenet.com
Click to expand...
Thank you AlanSidman for the tutorial links. I will go through the same.

Would you know how this can be done via VBA?


Regards,
Don
 
Hi @vletm

Sure I will give it a try with the formulas (was a nice to know information).

I would be glad to know how this could be done via VBA code, so this can be executed always on demand (with a button)

Regards,
Don
 
inddon
Your previous thread was 'via VBA'
... and after that You learned ... way to solve it with Power Query as You would remember.
 
Hi @vletm

Yes, my original post is via 'VBA code' and that is what I am looking for. Knowing it to do with formulas is nice to know for me.

Power Query is something new for the users and for me too (which was for a diferrent post). However, they would like to see how this requirement can be done via VBA. If you would know, could please help me with the actual VBA code?


Thank you & regards,
Don
 
You must log in or register to reply here.
Back
Top