Hi all,
I've been wrestling with Excel and VBA for the last few days with no result. I'm a programmer so know how to structure logic, but VBA is... different (to put it nicely :P )
Anyway, I'm trying to write a function that will accept a range and a variable, checking on each row if the variable is in the required cell and then doing a calculation based on another cell.
SHEET LAYOUT
FUNCTION CALLPlease Login or Register to view this content.
To use this function you would have to select range B2 to D5 and provide a category, as so:
PSUEDOCODE (not working code, please advise)Please Login or Register to view this content.
So the expected result would be 18.Please Login or Register to view this content.
Any help very much appreciated.
- Damask -
Bookmarks