Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IFSUM | Excel Discussion (Misc queries) | |||
IfSum | Excel Worksheet Functions | |||
Help on ifsum | Excel Worksheet Functions | |||
IFSUM | Excel Worksheet Functions | |||
ifsum | Excel Discussion (Misc queries) |