if/then formula

J

JW

I have a current spreadsheet with dollars for each employee in their home
dept. this is the current formula I have -
=SUM(IF($A$2:$A$160=B178,$G$2:$G$160,0)). I want to expand the cell range to
163 but when I make this change, it tells me "#VALUE!". Help!!
 
M

Michael

Hi JW
MAke sure the new cells are formatted correctly and make sure they contain
numerical data and not text.
HTH
Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif or other formula needed for multiple data/critera results 3
SumIf equation question 6
Using SUM(INDIRECT()) 2
Global Change Of Formula Value 2
Function help 7
Adding certain cells in one column 4
Help with lots of formulas 3
Excel - Wich Function should I use? 1

Top