Results 1 to 17 of 17

macro to get formula answers with data

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-14-2010
    Location
    oman
    MS-Off Ver
    Excel 2003
    Posts
    384

    Post macro to get formula answers with data

    dear friends below formula work fine for me.but i need to get that formula answer with all data.
    ex-
    80+80=160
    but this formulas giving only last answer =160.i need see that 80+80 also.pls anybody can make macro for this.thanks.

    B5 cell
    =SUM(IF('Daily Production'!$D$2:$D$350="40/2",(IF('Daily Production'!$E$2:$E$350="SSP",'Daily Production'!$G$2:$G$350))))
    C5 cell
    =SUM(IF('Daily Production'!$D$2:$D$350="20/2",(IF('Daily Production'!$E$2:$E$350="SSP",'Daily Production'!$G$2:$G$350))))
    D5 cell
    =SUM(IF('Daily Production'!$D$2:$D$350="45/2",(IF('Daily Production'!$E$2:$E$350="PP",'Daily Production'!$G$2:$G$350))))
    E5 cell
    =SUM(IF('Daily Production'!$D$2:$D$350="16/2",(IF('Daily Production'!$E$2:$E$350="CP",'Daily Production'!$G$2:$G$350))))
    Last edited by johncena; 05-03-2010 at 12:49 AM.

Thread Information

Users Browsing this Thread

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

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