• 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.

countif sumif sumproduct

achu

Member
Hi Deepak,

can you help me to using code with Macro below given details


Countif
Sum If
Sum Product
IF and

Below my required data and attached file here.


Total Booking Total Aeea
Vakas
Indigo
Fern
Ivy
Periwinkle
Residency-3
Orion-3
Galaxy-2
Nakshatra
Bella Vista
From Date Total Booking Total Aeea
To Date
Vakas
Indigo
Fern
Ivy
Periwinkle
Residency-3
Orion-3
Galaxy-2
Nakshatra
Bella Vista
 

Attachments

  • customer name.xlsx
    35.4 KB · Views: 1
Achu - Please confirm if the attached screen shot contains the correct mapping in comparison to your rawdata..

Also, could you share an example with required output..
 

Attachments

  • Capture.JPG
    Capture.JPG
    26.2 KB · Views: 0
Your file says from date and to Date..., where is this data available...

Can you please share the sample result for couple of items..
 
Hey,

here attached sample file please do the vba code for sumif,countif, sumproduct

if possible do if and condition
 

Attachments

  • customer name.xlsx
    35.5 KB · Views: 0
Hey,

here attached sample file please do the vba code for sumif,countif, sumproduct

if possible do if and condition


Hi,

Check this!!

If the output are correct then i will process the VBA code.
 

Attachments

  • customer name (1).xlsx
    35.7 KB · Views: 2
Hi i need to try if cell a1 has date then get all data from row automate sync

please know me how.
 
Hi can let me know how to vlookup in beetween two Workbooks
 

Attachments

  • Ank 1.xlsx
    14.6 KB · Views: 1
  • Ank2.xlsx
    12 KB · Views: 0
Hi try the following code
Code:
Sub GetData()
    Application.ScreenUpdating = False
   
    Dim cnStr, query, Str, fileName As String
    Dim rs As ADODB.Recordset
    Dim i As Long
    fileName = "Yourfile Path here\Ank2.xlsx"
    cnStr = "Provider=Microsoft.ACE.OLEDB.12.0;" & _
              "Data Source=" & fileName & ";" & _
              "Extended Properties=Excel 12.0"
   
    For i = 2 To Sheet1.Cells(Rows.Count, "A").End(xlUp).Row
        Str = Sheet1.Range("A" & i)
        query = "SELECT  [Agreement Value] FROM [Sheet1$] WHERE [Code]= " & "'" & Str & "'"
        Set rs = New ADODB.Recordset
        rs.Open query, cnStr, adOpenUnspecified, adLockUnspecified
        If Not rs.EOF Then
            ActiveSheet.Range("K" & i).CopyFromRecordset rs
        Else
        MsgBox "No records returned.", vbCritical
        End If
    Next
   
    rs.Close
    Set cnStr = Nothing
 
  Application.ScreenUpdating = False
End Sub

Note:Click on Tools » References »Microsoft ActiveX Data Objects 6.1 in VBA Editor before using the code.
 
Hi

can u let sme know how to use sumifs match function

if my data is below given
 

Attachments

  • Formula-achu.xlsx
    13 KB · Views: 1
Hi ,

Where the ranges are a mix of vertically oriented and horizontally oriented ranges , use the SUMPRODUCT function.

Narayan
 

Attachments

  • Copy of Formula-achu.xlsx
    13.4 KB · Views: 1
No Dear you made formula wrong

i need if i change same cell not more then one cell

i have validation


Validation
Flat

Service tax
Vat
 
Hi ,

Sorry , but I have not understood ; if you want the total Service Tax , that is already available in the uploaded file. I have not understood what you mean by
if i change same cell not more then one cell

Which cell are you going to change , and what is wrong with the uploaded file ?

Narayan
 
Hi Narayan,


i have cell validation flat service tax vat if i change service tax then show all service tax amount if i change vat then show all vat amount
 
Back
Top