Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have a spreadsheet formua that I'd like to add a test to, for name in
another column. The formula is =SUMIF($F$3:$F$218,"="&A3,$G$3:$G$218) -SUMIF($F$3:$F$218,""&B2,$G$3:$G$218) In this case I want to test a name in column H and only count G if name is equal So far I know a bunch of ways....that won't work..LOL....can someone help me out thanks. Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If Statement? | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |