| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
SumIf equation question
Hi,
I'm using the below SumIf equation, however the range in Column G is a formula and so the sum always comes out to 0. Is there a way to get the below forumla to only sum the values in H if the formula in G shows a value, and ignore anything cells in G that are blank? (The formula in Column G is part of a IF equation with a VLOOKUP to a seperate spreadsheet) =SUMIF(G25:G80,"<1",H25:H80) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel equation question | Excel Worksheet Functions | |||
| How do it set up a SUMIF equation with 2 conditions | Excel Worksheet Functions | |||
| equation / function question | Excel Worksheet Functions | |||
| sumif and then regular equation to non selected cells | Excel Worksheet Functions | |||
| Quick question: What does "--" in an equation do? | Excel Worksheet Functions | |||
Threaded Mode
