| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional IF statement
Thank you Geoff, that worked great
Rick -----Original Message----- Try this formula =SUMIF(B8:B308,"BOB",A8:A308) Geoff "Rick" wrote in message ... I was hoping someone could help me figure out how to create a special conditional IF statement. What I would like is to put in cell C1 the sum of all cells from A8 down but only if the ajoining cell [B8 down] contains a specific word. Example: Column A8 down contains 300 different figures currently with the B8 down column containing 5 different supplier names making up the 300 adjoining cells. So in other words C1 would have the sum of 80 A cells that have adjoining B cells that contain the supplier name "BOB" I hope I described well enough to understand. Thanks in advance Rick . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional if statement | Excel Worksheet Functions | |||
| Conditional If Statement | Excel Discussion (Misc queries) | |||
| Conditional Statement | Excel Worksheet Functions | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| conditional statement | New Users to Excel | |||
Threaded Mode
