LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
RLD RLD is offline
external usenet poster
 
Posts: 11
Default IFSUM and IFSUMS - which to use and how

I have 2 sheets. They are as follows:

Sheet1:
A B C
1 Make Type Qty
2 Toyota Hybrid 20
3 Ford Hybrid 68
4 Nissan Sedan 95
5 Toyota Hybrid 11
6 Dodge Truck 15
7 Toyota Sedan 21
8 Ford Sedan 0

Sheet2:
A B C
1 Make Qty Hybrids Qty Sedans
2Toyota
3 Ford

I need B2 and C2 of Sheet2 to sum up the total number of matching data from
Sheet1. In other words, how do I get Sheet2 B2 to sum up the total number of
Toyota Hybrids in Sheet 1?
 
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
IFSUM Bob_O Excel Discussion (Misc queries) 3 November 1st 05 12:36 PM
IfSum TYE Excel Worksheet Functions 3 August 27th 05 06:02 PM
Help on ifsum TYE Excel Worksheet Functions 3 August 18th 05 12:50 PM
IFSUM TYE Excel Worksheet Functions 6 August 16th 05 12:08 PM
ifsum Mandy Excel Discussion (Misc queries) 1 June 22nd 05 06:32 PM


All times are GMT +1. The time now is 01:47 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"