| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if two arguments are true
I have data where there are dollar amounts as well as categories that I'd
like to calculate the dollar amount if two conditions are met. I'd like to count the number of items that are in the category "Repo" AND are greater than $250? I have no formula yet. Can someone please help? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count if two arguments are true
=SUMPRODUCT(N(A1:A100="Repo"),N(B1:B100250))
adjust the ranges to fit your needs. Bob Umlas Excel MVP "LWilson" wrote in message ... I have data where there are dollar amounts as well as categories that I'd like to calculate the dollar amount if two conditions are met. I'd like to count the number of items that are in the category "Repo" AND are greater than $250? I have no formula yet. Can someone please help? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count if two arguments are true
Thanks...I think this will do the trick!
"Bob Umlas" wrote: =SUMPRODUCT(N(A1:A100="Repo"),N(B1:B100250)) adjust the ranges to fit your needs. Bob Umlas Excel MVP "LWilson" wrote in message ... I have data where there are dollar amounts as well as categories that I'd like to calculate the dollar amount if two conditions are met. I'd like to count the number of items that are in the category "Repo" AND are greater than $250? I have no formula yet. Can someone please help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count AND arguments | New Users to Excel | |||
| Count if two arguments met | Excel Discussion (Misc queries) | |||
| count if with multi arguments | Excel Worksheet Functions | |||
| Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
| how do I count with multiple arguments | Excel Worksheet Functions | |||
Hybrid Mode
