| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find and add function between sheets
=IF(A8='Per purchase order'!A:A,SUM('Per purchase order'!H:H)) statement
"FALSE" =IF(A10='Per purchase order'!A:A,then,SUM('Per purchase order'!H:H)) statment "640" which is a total of all numbers in column H =IF(A13='Per purchase order'!A:A,then,('Per purchase order'!H:H)) statment "3" which is the number in H13 =IF(A16='Per purchase order'!A:A,productsum('Per purchase order'!H:H)) statement " FALSE " As you might see I want to look at column A on sheet 2, search column A on sheet one for the corresponding text, when found go to column H and add that number for each time that text is found I've been working on this for 3 days now, can it be done? -- I think I am, therfor I am, I think |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find and add function between sheets
Hi
If I understand your request correctly, then on Sheet1 =SUMIF('Per purchase order'!A:A,A8,'Per purchase order'!H:H) -- Regards Roger Govier "MLT" wrote in message ... =IF(A8='Per purchase order'!A:A,SUM('Per purchase order'!H:H)) statement "FALSE" =IF(A10='Per purchase order'!A:A,then,SUM('Per purchase order'!H:H)) statment "640" which is a total of all numbers in column H =IF(A13='Per purchase order'!A:A,then,('Per purchase order'!H:H)) statment "3" which is the number in H13 =IF(A16='Per purchase order'!A:A,productsum('Per purchase order'!H:H)) statement " FALSE " As you might see I want to look at column A on sheet 2, search column A on sheet one for the corresponding text, when found go to column H and add that number for each time that text is found I've been working on this for 3 days now, can it be done? -- I think I am, therfor I am, I think |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find and add function between sheets
Yes, thank you
** HAVE AN AWESOME DAY ** -- I think I am, therfor I am, I think "Roger Govier" wrote: Hi If I understand your request correctly, then on Sheet1 =SUMIF('Per purchase order'!A:A,A8,'Per purchase order'!H:H) -- Regards Roger Govier "MLT" wrote in message ... =IF(A8='Per purchase order'!A:A,SUM('Per purchase order'!H:H)) statement "FALSE" =IF(A10='Per purchase order'!A:A,then,SUM('Per purchase order'!H:H)) statment "640" which is a total of all numbers in column H =IF(A13='Per purchase order'!A:A,then,('Per purchase order'!H:H)) statment "3" which is the number in H13 =IF(A16='Per purchase order'!A:A,productsum('Per purchase order'!H:H)) statement " FALSE " As you might see I want to look at column A on sheet 2, search column A on sheet one for the corresponding text, when found go to column H and add that number for each time that text is found I've been working on this for 3 days now, can it be done? -- I think I am, therfor I am, I think |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut to find sheets | Excel Discussion (Misc queries) | |||
| find out which sheets refer to a cel | Excel Worksheet Functions | |||
| how to find gst work sheets | Excel Worksheet Functions | |||
| how do i find which sheets contain links? | Excel Worksheet Functions | |||
| Find / Replace sheets vs workbook in VB | Excel Worksheet Functions | |||
Hybrid Mode
