| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What formula/fn would I use to count multiple condition records?
I need a formula/function that would work to count the number of records that
have =7 in the 1st column, <7 in the 2nd column and =7 in the 3rd column. |
|
#2
|
|||
|
|||
|
What formula/fn would I use to count multiple condition records?
"Joshcat99" wrote in message
... I need a formula/function that would work to count the number of records that have =7 in the 1st column, <7 in the 2nd column and =7 in the 3rd column. Hope this works: =SUMPRODUCT(--(A281:A288=7),--(B281:B288<7),--(C281:C288=7)) Ciao Bruno |
|
#3
|
|||
|
|||
|
What formula/fn would I use to count multiple condition records?
=COUNTIF(A:A,"=7")+COUNTIF(B:B,"<7")+COUNTIF(C:C, "=7")
Vaya con Dios, Chuck, CABGx3 "Joshcat99" wrote in message ... I need a formula/function that would work to count the number of records that have =7 in the 1st column, <7 in the 2nd column and =7 in the 3rd column. |
|
#4
|
|||
|
|||
|
What formula/fn would I use to count multiple condition records?
Hi,
You may use the sumif array formula as well (Ctrl+Shift+Enter) =sum(if((range=7)*(range2<7)*(range3=7),1,0)) Regards, Ashish Mathur "Joshcat99" wrote: I need a formula/function that would work to count the number of records that have =7 in the 1st column, <7 in the 2nd column and =7 in the 3rd column. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting - multiple condition | Excel Discussion (Misc queries) | |||
| how to count unique entries with multiple condition | Excel Worksheet Functions | |||
| Filter Count of Records Retrieved. | Excel Discussion (Misc queries) | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Linear Mode
