Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula help
Hi,
Please see example I just want to have a formula on left on column B that will count all values in column A Note column A is the sum of C and D. column AcolumnB columnC columnD A+B b b 2 1 1 #VALUE! c c 2 1 1 2 1 1 #VALUE! 1 1 #VALUE! c c 2 1 1 2 1 1 Thank you |
#2
|
|||
|
|||
Hi
Obviously the formula in column is something like this (for cell A2 p.e.) =B2+C2 Replace it with formula =IF(OR(B2"",C2""),"",SUM(B2:C2)) (when you want to exclude all rows with any non-numeric values), or =IF(AND(B2"",C2""),"",SUM(B2:C2)) (when you want to exclude all rows with all non-numeric values) and copy the formula down. Now you can use usual COUNT/SUM/AVERAGE functions on column A. Arvi Laanemets "chi" wrote in message ... Hi, Please see example I just want to have a formula on left on column B that will count all values in column A Note column A is the sum of C and D. column AcolumnB columnC columnD A+B b b 2 1 1 #VALUE! c c 2 1 1 2 1 1 #VALUE! 1 1 #VALUE! c c 2 1 1 2 1 1 Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Cannot change a formula | Excel Discussion (Misc queries) | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) |