Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want to check the value of one column (A) and then depending on the
outcome add the value in the same row but column B to a total. Can I do this in a single cell formula or do I have to have an extra column that does the logic test and then a cell to do the totalling? |
#2
![]() |
|||
|
|||
![]()
Hi Maria
not sure of exactly what you want but does =IF(A1="Fred",B1,0) give you what you want? if not could you type out an example of your data and what you want to see (please don't attach a workbook just type it out) -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Maria" wrote in message ... I want to check the value of one column (A) and then depending on the outcome add the value in the same row but column B to a total. Can I do this in a single cell formula or do I have to have an extra column that does the logic test and then a cell to do the totalling? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup then Match and insert value from next column | Excel Worksheet Functions | |||
Lookup with multiple value return | Excel Worksheet Functions | |||
How can I make Excel return the text in column A only if there is. | Excel Worksheet Functions | |||
How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
double lookup, nest, or macro? | Excel Worksheet Functions |