Looking for a formula to do the following.
1. Search a range of cells, say A1 through Z25, for the word Monday. It will appear several times. Let's say Monday is in C3 and D4.
2. Each time Monday is found, OFFSET for the 6 rows directly below the word Monday.
3. Return the SUM the numbers in the OFFSET cells.
Thanks everyone!
Russ
Last edited by Russ Fuquay; 07-27-2013 at 12:08 AM. Reason: table didn't copy to thread
The function you're looking for is SUMIF()
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks