Home |
Search |
Today's Posts |
#1
|
|||
|
|||
this may be simple, sumif question
i have a column that gets 2 values in it either a number which could be 0,
or a blank. i would like to sum another column if the first one is empty(blank). column A column B 1.02 1 row1 2.22 1 2 0.00 1 3 1 4 4.44 1 5 so sumif(a1:a5,not empty,b1:b5) would equal 4 as column A row 4 is blank. can this be expressed. i cant use 0 as 0 can be a valid answer. thanks. jim |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simple chart question | Excel Worksheet Functions | |||
Simple Date Display Question | Excel Discussion (Misc queries) | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Simple question | Excel Discussion (Misc queries) | |||
Pivot Tables - "simple" question | Excel Discussion (Misc queries) |