View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] nathon.fuller@gmail.com is offline
external usenet poster
 
Posts: 3
Default logical function

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