I need VBA functions
- or -
Post a project like this2370
$$
- Posted:
- Proposals: 4
- Remote
- #1727843
- Awarded
Description
Experience Level: Intermediate
Hello,
I would need a VBA SUMIFS function ( with multiple IFS criteria) that automatically incorporates data from any new created worksheets. I would need another similar function that would be equivalent to an AVERAGEIFS.
For example, I have a total of 4 worksheets. The first one simply summarizes the data of the remaining 3. One of the things I need a cell in Worksheet1 to do is to find the total sum of specific cells in the other 3 worksheets, if two criteria are met. I would want for Worksheet1 to have the total sum of A5 from Worksheet2 + A5 from Worksheet3 + A5 from Worksheet4 subject to two criteria (such as cells B1 and B2 in each worksheet being equal to cells C1 and C2 in Worksheet1). If cells B1 and B2 in Worksheet2 do not meet both criteria, then A5 from Worksheet2 would not be incorporated in the total sum in Worksheet1. Same logic applies to A5 from Worksheet2 and A5 from Worksheet3.
I can send you the Excel document with an example after you respond.
Please let me know if you think you would be able to do this in the next few hours.
Thank you.
I would need a VBA SUMIFS function ( with multiple IFS criteria) that automatically incorporates data from any new created worksheets. I would need another similar function that would be equivalent to an AVERAGEIFS.
For example, I have a total of 4 worksheets. The first one simply summarizes the data of the remaining 3. One of the things I need a cell in Worksheet1 to do is to find the total sum of specific cells in the other 3 worksheets, if two criteria are met. I would want for Worksheet1 to have the total sum of A5 from Worksheet2 + A5 from Worksheet3 + A5 from Worksheet4 subject to two criteria (such as cells B1 and B2 in each worksheet being equal to cells C1 and C2 in Worksheet1). If cells B1 and B2 in Worksheet2 do not meet both criteria, then A5 from Worksheet2 would not be incorporated in the total sum in Worksheet1. Same logic applies to A5 from Worksheet2 and A5 from Worksheet3.
I can send you the Excel document with an example after you respond.
Please let me know if you think you would be able to do this in the next few hours.
Thank you.
Juan A.
100% (1)Projects Completed
2
Freelancers worked with
1
Projects awarded
100%
Last project
27 Sep 2017
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies