Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple conditions
Column C contains 2 sets of data
Column M contains 19 sets of data I need to write a formula that counts the all the data in column M for the first data set in C. After which I can do the same for the second set in column C Thanks thom |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple conditions
Need a better explanation!
Biff "Curtis" wrote in message ... Column C contains 2 sets of data Column M contains 19 sets of data I need to write a formula that counts the all the data in column M for the first data set in C. After which I can do the same for the second set in column C Thanks thom |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple conditions
Sorry, Eventually figured it out
=SUMPRODUCT(--($C$2:$C$200="A2"),--($M$2:$M$200=E$4) Thanks Anyway "Biff" wrote: Need a better explanation! Biff "Curtis" wrote in message ... Column C contains 2 sets of data Column M contains 19 sets of data I need to write a formula that counts the all the data in column M for the first data set in C. After which I can do the same for the second set in column C Thanks thom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup with multiple conditions | Excel Discussion (Misc queries) | |||
Counting Unique Records with multiple conditions | Excel Worksheet Functions | |||
Vlookup with multiple conditions | Excel Worksheet Functions | |||
SUM based on multiple conditions - SORRY, URGENT!!! | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |