+ Reply to Thread
Results 1 to 3 of 3

Make Sum of Data Validation Values From Data sheet in Report Sheet

  1. #1
    Registered User
    Join Date
    07-26-2014
    Location
    india
    MS-Off Ver
    2010
    Posts
    66

    Make Sum of Data Validation Values From Data sheet in Report Sheet

    Hi

    I have attached file where multiple sheets are there
    In Food Purchase sheet I used Drop down in B column
    Same Fields are available in my Report Sheet from cell B 198 to B 212

    I want to fetch sum for those fields from Food Purchase sheet in column I (marked Red) I 198 to I 214

    eg in food purchase sheet total cheque amount for DRY STORE / GROCERY is 19500/-
    then it should reflect in Report sheet in cell I 98 marked red

    Same time in Food Purchase sheet G3 value will greater than D3 (Marked Red),
    then it should give Error alert massage for Budget crossed via Data Validation

    Please help
    Atul

  2. #2
    Registered User
    Join Date
    07-26-2014
    Location
    india
    MS-Off Ver
    2010
    Posts
    66

    Re: Make Sum of Data Validation Values From Data sheet in Report Sheet

    I tried this formula also
    =SUMIF('Food Purchase'!B9:B340,B198,'Food Purchase'!D9:D340)
    Figure comes perfectly but when I put From Date to To date in Report sheet (H4 and H5)
    then Value doesn't change

    Please help
    Atul

  3. #3
    Registered User
    Join Date
    08-24-2014
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2007
    Posts
    40

    Smile Re: Make Sum of Data Validation Values From Data sheet in Report Sheet

    Done. Pls check.
    Thanks zaroor bolna bhai. :p
    waise i am looking for job. can we talk ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 07-10-2013, 02:33 PM
  2. Replies: 1
    Last Post: 03-11-2013, 05:37 AM
  3. Kindly assist to consolidate data from raw data sheet to report sheet
    By ejima in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-30-2012, 10:11 AM
  4. Retry: Make a Data Validation List On Another Sheet Grow With New Entries?
    By leaning in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-18-2010, 07:01 AM
  5. Replies: 3
    Last Post: 05-12-2007, 08:12 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1