LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default Sumif but taking a value

Must be pretty simple but not sure how to do it.
I have a sumif function doing a summary of quantities, but I also need to
get the unit used in these quantities.
abc 5 m
ert 3 l
dfg 9 m2
abc 7 m
dfg 6 m2

With sumif in my summary I now I have 12 abc, but I need the unit in a
column too.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Taking away a percentage from a sum. the-jackal New Users to Excel 3 December 4th 07 02:06 PM
Taking out Emptys [email protected] Excel Worksheet Functions 1 October 19th 07 07:54 PM
Taking off or hiding #N/A FC Excel Discussion (Misc queries) 4 August 4th 07 09:36 PM
taking two worksheets together Jens Ravens Excel Worksheet Functions 3 June 3rd 06 07:48 AM
Taking Attendance L.Paul Excel Discussion (Misc queries) 2 April 19th 05 08:27 PM


All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"