Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help what kind of formula?
I've used Excel formulas in a basic way (sums, averages, divisions, and multiplication of cell data) for about a year. I came across this formula today for a project I need to complete. I've never seen the "SUMIF" or the dollar symbol, OR the ampersand! After hilighting the formula to see if I could just figure it out, I'm stumped. Any chance someone could explain what function these symbols serve Here is the formula =SUMIF($D$3:$D$28,"="&$C38,H$3:H$28) -- Emil0 ------------------------------------------------------------------------ Emil0's Profile: http://www.excelforum.com/member.php...o&userid=31232 View this thread: http://www.excelforum.com/showthread...hreadid=508999 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help what kind of formula?
The $ symbol is used to make the cell references absolute - if you had
a formula which referred to D3 and copied this down the column, it would become D4, D5 etc, and if you copied it across the row it would change to E3, F3 etc. Sometimes you do not want this to happen, so the $ symbol in front of the row or column reference prevents it from changing. The ampersand is used to join text together and is known as the concatenation operator - it does the same job as the CONCATENATE( ) function. In your example, the equals sign is being added to the beginning of the contents of C38. The SUMIF( ) function allows you to add values together if some condition is met. In your formula, the values to be added are in the range H3 to H28, and each cell of this range will be summed if the contents of the corresponding cell in the range D3 to D28 is equal to the contents of cell C38. Hope this makes things a bit clearer for you - you can find more details in Excel Help. Pete |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help what kind of formula?
I took a class several years ago but I had forgotten that use of the $ symbol makes the cell references absolute. Thanks for the reminder as I've never put this symbol in practice. And, I did find some info in the Help contents, but your examples referencing my formula directly helped. Appreciate it, Pete! :) -- Emil0 ------------------------------------------------------------------------ Emil0's Profile: http://www.excelforum.com/member.php...o&userid=31232 View this thread: http://www.excelforum.com/showthread...hreadid=508999 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help what kind of formula?
Well, thanks for getting back: I'm glad you got something out of it.
Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
What kind of Formula?? | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |