Calculting SUM of cells with IF functions inside

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a bunch of cells with IF functions inside to give me a dollar amount
based on the employees age. My IF functions are working properly. However,
when I try to insert a SUM function at the bottom to get the total cost, I
get a 0. Why won't it total my columns just because there's an IF function
in each cell?
 
Hi!

It sounds like your IF formulas may be returning text or the cells that the
formulas are in are formatted as text.

What does a typical IF formula look like?

Biff
 
You must log in or register to reply here.

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

CONCATENATE & LOOKUP Functions 0
Sum Visible Cells 5
Using text and formatting sum function in formula 2
Using Text to Columns with a function 6
Differnce function and argument for amounts in adjacent cells 3
Function for summing or counting cells based on a specified fill color 2
Created IF functions - Need sum of results 4
Problem with LARGE function 3

Back
Top