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 CALL![]()
Please 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