11-05-2009, 03:20 AM
Quote:The SUMIF command should do it. E.g.
=SUMIF(JAN!A1:JAN!x26,"Food",JAN!B1:JAN!x26) or something along those lines, I believe.
~FragB)
Wow it worked! Thanks a million. I thought you'd have to tell the cell specifically where to retrieve the data, but I guess if you displace it by one column, it automatically does it. It's so simple that I didn't think it would work, lol.
Concillian is correct though that if you know how to use VB, you can create your own macros to do just about anything. I'd love to get back into that. Some of my fondest memories as a kid (this sounds so geeky as I write it out, but its true) were creating programs in Basic on my dads Atari ST. That was back when you had to give every line a line number, i.e. 001 Begin. Now with Excel and Macros, it reminds me of a sandboxed version of VB made specifically for the end user. Someday, time permitting, I'll get back into it.
"The true value of a human being is determined primarily by the measure and the sense in which he has attained liberation from the self." -Albert Einsetin