LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Emil0
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM
adding row to forumla carrera Excel Discussion (Misc queries) 9 August 23rd 05 10:24 PM
What kind of Formula?? Mike R Excel Discussion (Misc queries) 0 February 17th 05 04:17 AM
Match / Vlookup within an Array formula Hari Prasadh Excel Discussion (Misc queries) 3 February 3rd 05 04:37 PM


All times are GMT +1. The time now is 03:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"