Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Let me start by saying I am fairly new to logical functions. I have
searched a bit on this and was unable to locate an answer to the function i would like to do. what i would like to have a function do is add all in a row if text in an colum is true. here is some sample data a b c 1cash $5.00 $45.00 2cash $45.00 3check $35.00 4credit $50.00 what i need to happen is if col a=cash then add b#+c#. This function would need to hold true for the entire colum in the one cell. with going off this sample data i have provided i want 1 cell to add b1, c1, b2, c2 together because they have 'cash' is the col of 'a' 1 more note this needs to work with upto 25 rows. Now i know i have not explained myself all that well and for that i appologize for that. If there is any other info you need from me please feel free to ask. Thanks -TheChef420 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
wild card with if logical function | Excel Worksheet Functions | |||
Custom function | Excel Worksheet Functions | |||
Logical Function Question | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
using logical functions as criteria with the SUMIF function | Excel Worksheet Functions |